We have 2 EV servers, each with its own SQL 2000 server. We are looking to consolidate these 2 sql 2000 servers into a single sql 2005 server in expectation of upgrading to EV8.
In preparing for the moving of databases to the new server, I have a conflict with the EVConfiguration database, as it exists on both of the SQL servers.
Do I need to only copy one of these databases into the new sql server or is there a way to reconnect both with different names? Or do I somehow need to merge the DB's?
If the data is the same in both, then I suspect I only need one of the two databases on the new SQL server.
Thanks in advance.