Question Changing server behind DataSet

[TCW78]

I have an application that uses a database, I have my dataset with different tables and methods for each tables.

The current server where the tables are is to be closed in the next weeks, my question is simple : is there a way to tell VB.Net that my tables are on server X instead of server Y without having to delete all tables in my dataset and recreating them and all their methods?

Thanks

 

[TCW78]

Found it!

Got to change the connection strings in the app.settings and the settings.settings files. Way lot faster than having to delete all tables and add those of the new server.

 

[cjard]

If you ever want to change it at runtime, let me know

 

[MattP]

If you ever want to change it at runtime, let me know

Excellent example of changing connection string at runtime for those intrigued by cjard's post.

How Do I: Modify Connection Strings at Runtime?

 

[cjard]

nice find, different to my method and probably better because it's less likely the developer will screw up the dataset