SQLTeam.com | Weblogs | Forums

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 the process should merge the current schema updates and add if any new schema found (same for data as well).