migration on the same server. - SQL Server Forums

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

SQL Server Administration (2005)

migration on the same server.

Author

Topic

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2010-09-08 : 04:40:59

Hello,

I am in the process of transferinig all the tables (With data), stored procedures, functions, etc. from a database (DB2) into another database (DB1).
What is the best way, options to create the required scripts to do this?
Note that this will have to go through the Dev and then UAT and then Production. So I will have to have a set of scripts to run on each server.
Using the wizard, I have created the scripts to create the required objects.
Should I have a separate step to transfer the data?

Thank you

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-08 : 11:45:10

Use backup/restore for this. Do NOT use the wizard as it does not give you an exact copy.

Here's what I use to automatically refresh environments: http://weblogs.sqlteam.com/tarad/archive/2009/02/25/How-to-refresh-a-SQL-Server-database-automatically.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog