I've created a vbnet application in visual basic that connects to sqlexpress database on the same computer on which I created the application. I use the connection string:
Dim cs As New SqlConnection("Data Source=myPC\SQLEXPRESS;Initial Catalog=myDatabase;Persist Security Info=True;User ID=sa;Password=password")
It works fine.
However, I have decided that I would like to be able to install the application onto other computers which are not connected to my server. So each application will have its own embedded database, with a button to sync the data with a mySQL database held online.
Do I have to create a whole new database, including all the tables etc? Or is there away to recreate the sqlserver held on my own PC onto the machine I am installing the application on?
I hope this is clear?
This post has been edited by andrewsw: 01 September 2013 - 04:18 AM