Which are the correct steps to follow so my VB applications connected to a local instance server could connect to a remote one??
Saturday, February 16, 2013 3:48 AM
Hello to all. My question is large but simple:
I have a VB project created in Visual Studio 2012. I have some queries saved in the data set and I'm connecting to the server running in my own computer (my default SQL Server 2012 instance). I have my queries which I created using the query builder (I wrote the queries, didn't use the GUI) and the binding source, binding navigator and table adapter are created. You know... all of those component are created by Visual Studio itself when you drag and drop the database controls from the "Data Sources" windows. My connection string and my App.config is this one:
<?xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> </configSections> <connectionStrings> <add name="Ultimate_Video_Games_Organizer.My.MySettings.GamesInfoConnectionString" connectionString="Data Source=SAMYCODE\SAMYCODESERVER;Initial Catalog=GamesInfo;Integrated Security=True" providerName="System.Data.SqlClient" /> </connectionStrings> <startup> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" /> </startup> </configuration>Now HERE'S come my question. If I migrate my db to a remote server. The ONLY THING that I have to change is my connection string?? And what about all the components created by Visual Studio like the Table Adapter, Binding Navigations and etc which were created when I dragged and dropped the components from the Data Sources windows... I wouldn't lose them? I just have to connect to the remote server and all my queries in the data base and all the things with the db that worked in my application using my local instance server will work as well only changing my connection string? I guess not. I really don't know and I'm still a noob. I need an explanation so please, I will be waiting for your answer.
Thanks in advance!!!