how to transfer a database entirely ?

6cet6 · December 3rd, 2003, 07:09 AM

hello everybody,
May i have a question?

i want to transfer a database entirely to a new SQL server,
includ all the tables,stored Procedures,views and so on
but needn't have the data

how could i do this?

thanks

nbryson · December 3rd, 2003, 07:42 AM

Hi

You can do this from Enterprise Manager. Right click on your database then choose 'All Tasks' then 'Generate SQL Scripts'. From this window you will be able to create script files to generate Tables, SPs, views etc, by object or 1 file etc.

Nickie

happygv · December 3rd, 2003, 07:43 AM

You can backup from on server and restore it in the other. But You would get them all with data in it. May be you can truncate all the tables once you restore it on the new server. I dont think SQL has some utility to backup and then restore the database without data in it.

You can check for Backup and restore on Books online.

Cheers,

-Vijay G

6cet6 · December 9th, 2003, 06:55 AM

I think nbryson's advice is a good idea,I would try it

jemacc · December 9th, 2003, 06:35 PM

something extra to add. If you don't want to setup account and logins again.Here is an article that will help in the process. http://support.microsoft.com/default...en-us%3B246133