>>>Hi,
>>>
>>>I have asked this questions some long time ago. The question was/is, I have an existing database in the SQL Server 2005. I want to add a new database to the SQL Server of the same structure but empty. The notes I took back then from the suggestions given to me were the following:
>>>
>>>Right click on a DB and select Script Database AS, CREATE TO FILE.
>>>
>>>But when I follow the step above and look at the script I see nothing about the tables that the script should have. Am I missing something in the above step?
>>>
>>>TIA.
>>
>>Right click on the database, Tasks, Generate Scripts and then follow the Wizard.
>>
>>See this good tutorial
>>
Generate Script with data from database using Publishing Wizard>
>I have created the script of the database all all objects. What is the syntax to add to the script to execute it so that a new database is created (of some different name)?
Look at the top portion of the script and modify as needed to use new database. Also do a find/replace for all occurrences of the Old database name to the new database name.
If it's not broken, fix it until it is.
My Blog