Can we modify connection string to database data source (not info link) that uses SQL database?
I have data tables that were added using database and select SQLClient Data Provider. We are changing the server name. Is there a way to update the connection strint such as in this example?
1. Select File > Add Data Tables...
Connection string: Data Source=XXXD01;Integrated Security=True
> change data source from this from XXXD01 to XXXD02
Or is the only way to do a replace data table?