Is there an easy way to update connection strings to a database moved to a different instance I have created a new instance of SQL Server 2008 r2 and exported my database to the new instance.  Then I realized that the connection string for all of my datasets still point to the original database.  Is there an easy way to update the connection string for each of the datasets?

This also brings a question on deployment.  Each customer that purchases the software would have a different connection string.  Can you point me to some documentation that would explain how to handle this scenario?
Is there an easy way to update the connection string for each of the datasets?


Connection strings are what client software use to figure out how to connect to the data store. So I would say outside of a programmatic update (search and replace) no there is no straightforward or native way to do this.


  Each customer that purchases the software would have a different connection string. Can you point me to some documentation that would explain how to handle this scenario?


This is really more of a question of software install/deployment/configuration, but typically setting the connection string would be done through the installation process.