Copy database from one server to another
SQL Server 2000 had an option that allowed you to copy a database from one server to another. This option copied schema and data all in one move. We used the option frequently to copy production databases from production to development servers. Your software can do this, but requires several steps.
Gary Jorgenson
shared this idea
We would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server.
-
Neolisk
commented
As described, this is a very bad approach. It is easy to do, but it may introduce a lot of problems down the road. And I really mean *a lot*. You should better use schema and data comparison.