>>>>>>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.
>
>Aside from the database name you need to change the file names as well in the CREATE DATABASE command. You could set the file sizes small since you are starting a new database as well.
I looked at the script that SQL Server created and I don't see the command CREATE DATABASE. The script starts with the following lines:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Do I understand you correctly that I need to add the line CREATE DATABASE MyDbName right before the first SET command?
"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