Consolidating databases sql server

Posted by / 15-Nov-2017 02:07

Consolidating databases sql server

SQL-Hub ( will let you merge multiple databases with the same schema in to a single database.

This course will show how to effectively plan and implement a consolidation strategy, including methods of consolidating, and ways to migrate databases and instances.If you want to have full control over the merge process you can code it in SSIS.But if Transaction Replication can now even cope with schema changes and you have lots of tables to consolidate I can see the advantages of that.I cover ways that you can identify consolidation candidates in your environment and make recommendations on which type of servers you should consider consolidating first.I wrap up the course going over various migration strategies.

consolidating databases sql server-47consolidating databases sql server-86consolidating databases sql server-68