A
AndyNakamura
Guest
I've developed a vb.net application that uses an Access db as it's database.
Now I'd like to update it (As recommended)to use sql server express.
I've done a bit of investigation and some testing, also migrated the db to sql server express 2012
and a lot of it works just by changing to sqlclient and using a different connection string and a bit of modification of the sql statements.
But before I start in ernest, there are a few things I'm not sure about.
I use a commercial CAD system. The version I am on currently is 2016, however I see they are still shipping it with sql server express 2008.
So that made me wonder if 2017 is the best version to develop against?
The current application is deployed by using clickonce, I just deploy the app with the database and have some prerequisites like
accessdatabaseengine.exe and the .net framework. If they don't exist on the target computer they get downloaded from microsoft.
Is it possible to deploy sqlserver and the actual database files in a similar fashion?
Continue reading...
Now I'd like to update it (As recommended)to use sql server express.
I've done a bit of investigation and some testing, also migrated the db to sql server express 2012
and a lot of it works just by changing to sqlclient and using a different connection string and a bit of modification of the sql statements.
But before I start in ernest, there are a few things I'm not sure about.
I use a commercial CAD system. The version I am on currently is 2016, however I see they are still shipping it with sql server express 2008.
So that made me wonder if 2017 is the best version to develop against?
The current application is deployed by using clickonce, I just deploy the app with the database and have some prerequisites like
accessdatabaseengine.exe and the .net framework. If they don't exist on the target computer they get downloaded from microsoft.
Is it possible to deploy sqlserver and the actual database files in a similar fashion?
Continue reading...