Hi I have to consolidate 12 dbs ona server to a single database.The databases are having same objects. and few tables don't have primary key in them. Please suggest a work around for this Sumit
Welcome to the forum. What is the relation between primary key and databases count? There isn't any, in this case have you tested or compared the current hardware and upcoming hardware of the servers to ensure those 12 databases can cope up with available resources. What kind of changes you are going to make on the SQL server memory? See the blog posts below: SQL Server consolidation & keeping up performance at the same time SQL Server consolidation and virtualization - hot topic in the industry What are advantages of 64-bit system in relation to SQL Server? Streamlining migration and consolidation - Servers SQL Server 2005 Design Considerations for Migration
