Database Problem

[Guest_imported]

Hi,
Here is my Problem:I have a Database(name-Test) with so many tables,views,StoredProcedures.....etc.I need to create a new database, and while doing so my Test Database should serve as a skeleton Structure for my new database.
That is all my tables ,views,storedprocedures ..etc of test database should fall inside my new database.(I mean without data)

 

[cdukes]

Create a script of the old database as a single file, scripting all objects (tables, SP's ) etc.

Run the script on the new database.

Chris Dukes

 

[dtrumbower]

I would use DTS to copy the structure from Enterprise Manager.

Dwight

 

[Guest_imported]

Hi cdukes,

Thanx a lot.But I have Got one more doubt.
How Iam supposed to script the whole database,Is there any Sql Options for this? or Should I Create a script for each and every object in the database.

 

[fluteplr]

Well lets see, that ought to be really hard. Enterprise Manager, right click on the database name, choose all tasks from the popup menu, choose generate sql script, pick the options you want, press OK and wait about two minutes.

Seriously, does anyone on this forum ever read the manual???

 

[Guest_imported]

hi fluteplr ,

Thats a very nice suggestion,but unfortunately I have to achieve this thro' coding b'coz I need to do this at run time.I hope u understand.We all read the manual perfectly...Can u give suggest me some other option pl.

 

[cdukes]

You could use SQL DMO objects which allows you to completely script the database in VB. We have written a VB task that is schedules every night to completly script the databases.

Chris Dukes