SQL Server database consolidation

[eileen1017]

Right now, I have several servers with the same database name on different servers. But now I need to consolidate those databases onto one server. Obviously, I cannot have on server with five or six databases with the same name. How will I approach the migration differently? Right now I start the consolidation with the databases with different names first and I used detach and attach method. If I create a new database with a new name on the new server, how will I go about migrate the data from old database with a different db name? Thanks.

 

[mrdenny]

When you attach the database's where the same already exists, simply change the name of the database when you attach it.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog