>>>>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.
Thank you very much.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham