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...

Source: Database

Provider: System.Data.SqlClient

Connection string: Data Source=XXXD01;Integrated Security=True

SQL statement:

 

   >   change data source from this from XXXD01 to XXXD02

 

Or is the only way to do a replace data table?

(1) Answer

Login