>>>>>I was thinking of dropping the original database too, but perhaps we can keep the original and create a new database using the script?
>>>>
>>>>This is what I hope to do. I will make a backup of the existing one first, just in case.
>>>
>>>Right, also good point from Borislav to add USE myNewDatabase at the top of your script.
>>
>>Success! What surprised me is that it took (what seemed like) less than a second - very fast.
>
>If you haven't scripted the data, then it should be very quick to create all objects.
By "scripting the data" you mean "creating/adding rows of data to tables"?
"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