Migration from multiple databases to a single one in different schemas

rodrigoasf

I would like to know if, among redgate's portfolio of solutions, there is any tool that can help me with a migration of 5 Sql Server databases to a single database, separating each source database as a schema.

The biggest database we have at the origin has about 600gb.

Robyn

Hi, 

Thanks for your question. 

I think you could use SQL Compare and, by first creating the 5 schema on the target for each of the 5 different source databases you could map the owners as described on https://documentation.red-gate.com/sc/setting-up-the-comparison/mapping-owners and compare each of the 5 source databases to a different schema on the target to get the schema structures there and then do the same owner mapping using SQL Data Compare https://documentation.red-gate.com/sdc/setting-up-the-comparison/mapping-owners. 

If you would like to obtain a trial license to test it out contact us on sales@red-gate.com!