question

schindam26 avatar image
schindam26 asked

MS SQL Server- Consolidating multiple database objects into one database

Hi all, I would like to consolidate my 5 databases into one database, here, I would like to load all my database objects with data. Can anyone help me the best and easiest approach to consolidate? and It should not one time process, I would like to automate the process where process should merge the current schema updates and add if any new schema found (same for data as well).
sqlserver-2012database-objectsconsolidation
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
is this one database just a read-only consolidation of the other five databases? If so, I would lean toward transactional replication to keep things in synch. https://docs.microsoft.com/en-us/sql/relational-databases/replication/transactional/transactional-replication https://technet.microsoft.com/en-us/library/ms147331(v=sql.105).aspx
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.