Hi,
In sql 2000 was possible to copy entire database objects from one db to another. This includes tables, pk, indexes, views, sp, functions, logins and so on.
This is very usefull because at the same time it creates a full log with entire database scripting, it can be used to track changes in databases.
In sql 2005, I can't find a solution like this.
Someone have an idea to this?
Hi
Even in SQL2005 you can copy whole database with complete schema intact using SSIS (Transfer database task).
Thanx
No comments:
Post a Comment