Consolidating sql databases
I need to consolidate 20 databases that have the same structure into 1 database.I saw this post: Consolidate data from many different databases into one with minimum latency I didn't understand all of this so let me ask like this: There are some table who have primary keys but don't have source ID, example: Data Base 1 what are you trying to accomplish (application consolidation, reporting, warehousing)?These are some of the questions that are answered in this session, along with key best practices and caveats learned from dozens of consolidation projects that range from a dozen to over 4,000 SQL Server databases.This session explores key considerations in a consolidation project and common oversights that derail the project.The problem first time was that I didn't set "Action if name is in use" flag to "Keep existing object unchanged".Default is "Drop existing object and create a new one"[email protected] (As always) it depends.While cost reduction was the #1 response to what is driving the desire for SQL consolidation, this was tempered by the top three issues concerning respondents when it came to consolidation — Performance (74%), High Availability (51%) and Manageability (40%).
This is consistent in what we see in the field and marketplace; cost efficiency and new features enabling better performance, availability and management are driving our clients in the same direction.
Will the 20 databases still be used after this process is over?
Also, what are the approximate sizes of these databases as well as the number of tables in each?
I had a lot of fun working on this course and owe so much to Paul Randal and my team for their help and guidance as I learned the process of recording for Pluralsight. The course modules are: This entry was posted in Presentations, SQLServer Pedia Syndication, Training/Events and tagged Pluralsight, sql server, SQL Server Consolidation, SQL Server Consulting, SQLskills.
Gridstore recently conducted a survey of over 125 Enterprise IT professionals a number of detailed questions surrounding the issue of SQL Server consolidation, including the business challenges driving their changes.
Search for consolidating sql databases:
In the recent years, there have been a few different trends related to the hardware platform for SQL Server.