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.
Comments
1 comment
-
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!
Add comment
Please sign in to leave a comment.