Swamp_Thing
asked on
How to merge two SQL servers onto one
We have two servers each running MS/SQL 2005. Each has several databases. each has ( one several and one many ) SQL Agent Jobs and Local DTS Packages. We are replacing our two existing SQL Servers with one beefy server and will be installing a single instance of MS/SQL 2008. I need to migrate and consolidate the two existing servers onto this one new server. I'm OK with the databases as they all have unique names but I'm concerned about the Agent Jobs and DTS Packages. How do I consolidate these onto the new machine? I suspect I can use the Generate SQL Scripts on the Jobs but have no clue as far as the DTS Packages are concerned... Help ( and cautionary tales ) from this community GREATLY appreciated ( the more detailed the better )...
Thanks !
Thanks !
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yup - according to http://msdn.microsoft.com/en-us/library/ms143531.aspx I'll be able to create a named instance for each of the "old" servers. This is going to make life So much easier...
ASKER
Splitting the points 3 ways with the lion's share to DFW_Ed as he answered the question directly. The best answer, from both Ed and Lowfat, is multiple instances ( which I did not know were supported ).
ASKER
Now - if I could install multiple instances of SQL Server 2008 on the same server I'd go for that but I don't believe MS/SQL Server 2008 Standard allows for that...