Posted by Erland Sommarskog on 01/12/07 22:05

Jer (jerry.w.black@saic.com) writes:
> I just upgraded to SQLServer 2005 Standard. I do development in a
> database on one server. When a solution is completely tested, I move
> it to the operational database on a different server. With SQLServer
> 2000, I could just open the .adp file and do File->Get External
> Data->Import to move the objects. That does not work with 2005.
> What is the recommended method for moving objects from one database to
> another? Obviously, the objects that changed will not be the same
> every time.

The recommended method is to have all SQL objects under version control
and build all install kits from the version-control system.

At http://www.red-gate.com you can find SQL Compare, which many people
use for this sort of thing.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]