SQL DB Creation Code - Is it available?

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
__n3o__ Members Profile Find Members Posts Groupie Joined: 08 November 2005 Location: United Kingdom Status: Offline Points: 135	Post Options Post Reply Quote __n3o__ Report Post Thanks(0) Quote Reply Topic: SQL DB Creation Code - Is it available? Posted: 21 January 2007 at 6:35pm
	This might be a strange question - But I want to create a fresh new WWF SQL DataBase but I want to run the query directly in SQL Express... Is this available - The actual SQL Code.... To save me hacking the mssql-setup ASP page up....?? I can't see it being any problem letting be available?? ... Thanks

MadDog Members Profile Find Members Posts Mod Builder Group Joined: 01 January 2002 Status: Offline Points: 3008	Post Options Post Reply Quote MadDog Report Post Thanks(0) Quote Reply Posted: 21 January 2007 at 9:50pm
	WebWizForum does not have any SQL code to create a/the MSSQL database. It only sets up the tables and other stuff to a already created database.


__n3o__ Members Profile Find Members Posts Groupie Joined: 08 November 2005 Location: United Kingdom Status: Offline Points: 135	Post Options Post Reply Quote __n3o__ Report Post Thanks(0) Quote Reply Posted: 22 January 2007 at 9:52am
	Sorry fella thats what I meant - I have created an empty DB in SQLExpress then just want to run the query to create all the tables, relationships etc.. etc.. Is this available?

dfrancis Members Profile Find Members Posts Senior Member Joined: 16 March 2005 Location: United States Status: Offline Points: 442	Post Options Post Reply Quote dfrancis Report Post Thanks(0) Quote Reply Posted: 22 January 2007 at 10:06am
	If you us EM, you can easily create the SQL by highlighting all the tables, right click and select all tasks/generate sql. If you hit the preview button you can see that all of the tables are right there. To get the indexes and everything, you'll have to select several options but in the end, it will generate the sql for you. You may have to hack a little for the value inserts but that's small stuff. Good luck.
	“If you want things to be different, you must be willing to do different things!”David Francis

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.