SQL DB Creation Code - Is it available?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=22469
Printed Date: 08 April 2026 at 6:34am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL DB Creation Code - Is it available?
Posted By: __n3o__
Subject: SQL DB Creation Code - Is it available?
Date 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 |
Replies:
Posted By: MadDog
Date 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.
------------- http://www.iportalx.net" rel="nofollow"> 
|
Posted By: __n3o__
Date 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? |
Posted By: dfrancis
Date 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!” http://www.DavidFrancis.org/?wwf=signature" rel="nofollow - David Francis |