title: Swap Database in visual studio from Access to SQL
body: <p>I have created a windows form project which is based in vb.net in Visual Studio. This form acts as the front end to the database.</p>
  
  <p>I decided this time round to try use the Dataset Designer in Visual Studio and found it convenient. Using the Wizard I linked up the MS Access database to create the Dataset in the project. This then automatically generated all the relevant table adapters, datasets, bindingsources and so on.</p>
  
  <p>Now, the aim is to transition the same Access database to SQL-server. 
  <strong>The Question is whether it is possible to simply swap the Dataset in Visual Studio to from Access to SQL which have the same table names, structure, relations...</strong> I tried modifying the connection string in Settings.settings with no success.</p>
  
  <p>This would save me a lot of time from going through each object and updating the datasource to the new SQL database.</p>