Moving a Database

• co_patrickf

  SSC Enthusiast

  Points: 130

  More actions

  June 13, 2002 at 9:48 pm

  #58461

  I have a simple question about moving a Database.

  I want to consolidate 3 machines each running SQL Server onto 1 machine. None of the database names are the same.

  1. I think I can detach the individual databases from each machine and reattach them on the new target machine. Yes/No?

  2. I think I can add WINS/DNS address to alias the orginal machine names (ServerA, ServerB, ServerC) to the new machine name (GIGANTIC1). This allows existing ODBC applications to use the original machines names to connect (and DSN connections). Yes/No

  The problem is, if one of the SQL installations was a named instance (ServerB\PATRICK1). and I move it to (GIGANTIC\PATRICK1) I don't appear to be able to use the trick of aliasing the machine to access the DB via the existing applications that use the "old" machine name to connect through ODBC.

  Any advice?

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 14, 2002 at 6:32 am

  #430886

  Your statements are correct except last.

  1 yes,

  2 yes,

  3 Might be able to use WINS to generate and alias or LMHOST file on the machines (but that is what WINS does). Because you map a WINS name to an IP.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)