Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbutch1976
Starting Member
7 Posts |
 Posted - 2009-08-14 : 09:38:21
|
| Hi Everyone,I am a little new to SQL admin. I have been tasked with taking serveral instances of SQL which are of different versions (2000, 2005) and hosting them on a single SQL 2005 server.What are the steps I will need to follow in order to do this? After the databases are moved I don't want to have to reconfigure all of the client machines to point to the new databases, so can I use CNAME (alias) records in DNS to redirect the clients to the new IP of the new server?Thanks in advance. |
|
|
dbutch1976
Starting Member
7 Posts |
Posted - 2009-08-18 : 10:41:29
|
| Hi there,Any help with this request? I have a new 2005 SQL Enterprise Server and I would like to Migrate all of the existing SQL databases that exist on several different servers onto it. Are there some guidelines for doing this or will I have to do this on a case by case basis?Thanks. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-18 : 11:27:28
|
| do all clients connect by server name? or do some connect by IP address? |
|
|
|
|
|
|
Merging SQL instances