0

Thanks for viewing my question. I currently have a database on SQL Server 2005, which is being migrated to SQL Server 2008. Each SQL Server is named differently in SSMS. The old is named GARDB1, and the new GARDB2008. GARDB2008 is in production with everything running smoothly besides this is the last database I need to move over. Now, obviously both servers have different IP addresses, but I can add the old IP to the new server after migration.

My problem is in connecting too MANY different reports we have connected to the database after migration. The connection strings do not include the IP address, only the name GARDB1. There is also a website attached to this database.

How can I migrate this database to the new server while keeping everything connected? It is okay to have downtime while doing this. I tried creating a new alias in SQL configuration manager, but this did not help. What am I missing?

Thanks for any help!

Josh

Improve this question
2
  • Depending on the needs of the system (such as Kerberos usage,etc) it may be possible to just change the DNS records after the cut-over so that GARDB1 now resolves to GARDB2008's IP. While it would NOT be ideal for a long term solution, short term interim solution would suffice.
    – Sean Gallardy
    Jul 26, 2014 at 16:22
  • After ip address change, you would require an IIS reset on the web servers.
    – Kin Shah
    Jul 27, 2014 at 2:33

1 Answer 1

Reset to default
0

You can use CNAME in DNS. When you're done with GARDB1, rename it to something else (GARDB1_OLD). Create a CNAME in the DNS server called GARDB1 which should point to GARDB2008. It should solve your problem because GARDB1 will resolve to GARDB2008 now. Ideally what you need to have is a generic CNAME that you can just re-point to a new DB server each time you are migrating. Perhaps next time you plan to migrate, you can implement it. Or you could go with what @SeanGallardy suggested.

Improve this answer
1
  • I appreciate your feedback. Your answer lead me to the solution I needed.
    – Josh_with_questions
    Jul 28, 2014 at 18:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.