January 8, 2010 at 8:46 pm
every vendor came to us with his requirements and SQL Server one of them.
we start providing them as pair requirements but in the end we faced a problem, we have many servers for SQL Server. now we need a solution to centralize the databases.
please could you provide me the best solution and recommended way to centralized the databases with high performance and availability.?
Note: we are using SQL Server 2005 and 2008 , we going to use 2008 for centralization.
thanks in advance ..
January 9, 2010 at 2:04 am
If your databases are in one Server I think they are centralized, so if you mean to collect all databases in one ...one of the solution is to organize them with schema in one DB, exporting all objects in separate schema like in AdventureWorks, but it can show you problems with applications and you must do some changes in applications ( Conn strings, any part of CLR codes, any ADO configuration, any dynamic SQL code, etc etc). It depends from you applications.
January 9, 2010 at 6:47 am
What do you mean by centralization, I may be wrong, you may be referring to Consolidation as centralization.
Do you have multiple Instances on multiple servers and would like to consolidate into 1 single server? or Move all Databases to one Instance of SQL Server 2008?
Some details about your existing systems would provide an overview to start, and what is that you are trying to achieve finally?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 9, 2010 at 11:51 pm
dear Dugi
thank you for your kind response.
dear Bru,
sorry for the miss understanding, you are right ,we have multiple instance on multiple Servers and we would like to consolidate into 1 single server and we going to clustering the SQL Servers as well.
we going to move everything to SQL Server 2008.
thank you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply