Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 moving the database from one server to another ser

Author  Topic 

anthu_soft
Starting Member

8 Posts

Posted - 2009-10-22 : 03:32:06
I have a doubt about moving the database from one server to another server without data in the table.
I have a database in developement server. I want to move the database to my production server
I have using backup/restore and copy database method but these methods will move the data also.
i want only database with table structure (without data)
Is there any way to do it?
urgent reply needed.

Thanks in advance,
Anthuvan

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-10-22 : 04:08:56
Generate scripts and run them in the target server

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -