Last post Jan 23, 2017 09:51 AM by wmec
Dec 18, 2016 08:20 PM|peterthegreat|LINK
I have updated 2010 VSDE to version 2012. It appears running previous version of SQL server.
I would like to update the SQL Server to latest.
How do you find what version is currently running and is there a upgrade compatible with 2012 VSDE.
Dec 19, 2016 01:20 AM|oned_gk|LINK
Dec 19, 2016 04:37 AM|wmec|LINK
SQL server 2016 express is latest express version. Try
to get the version.
Dec 19, 2016 05:10 AM|Chris Zhao|LINK
To determine the version, edition and update level of SQL Server and its components, see https://support.microsoft.com/en-us/kb/321185.
Dec 20, 2016 06:10 PM|peterthegreat|LINK
Is it available for download ?
Also, do I have to remove previous edition before installation of SQL server ?
Dec 21, 2016 05:43 AM|eralper|LINK
You can install multiple SQL Server Express edition instances on the same computer.
Since you can install different SQL Server versions on a server without any problem, you will be able to install a newer Express edition on a PC where a previous version has already been installed.
Since Express edition instances are named as [ServerName]\Express by default, you will have to rename the second instance with a different name
Dec 24, 2016 03:38 PM|peterthegreat|LINK
Is it a simple task to attach and detach Local SQL Express versions from VSDE ?
Dec 26, 2016 09:24 PM|peterthegreat|LINK
How is a instance of SQL Server connected to my VSDE. I cannot do it through VSDE as i have tried!
Dec 27, 2016 12:49 AM|oned_gk|LINK
You can have multiple sqlexpress localdb.
You can download sql express localdb 2012 or 2014 or 2016 or all version
you can create/delete/start/stop intance using command line utility
You can also create instance for spesific sql version
For example, you have sql express 2016. if you want work with sql 2012 database file then you can install sqllocaldb 2012. Create an sql 2012 instance. Create connection string with to connect to the new instance.
AFAIK, you can't use newer sql file for older sql instance, for example you have 2014 sql database file and want to atach to 2012 sql intance.
To connect to the database, you can create connectionstring
Dec 29, 2016 06:19 PM|peterthegreat|LINK
Can you change the version of SQL Server connected to a database from within VSDE or do you require the command line utility to do that ?
On my system I now have multiple versions of SQL Server, namely 2008 and 2016 and want to swap over to the latter one, so what is the approach.
Jan 23, 2017 09:51 AM|wmec|LINK
You can then upgrade to relevant new version of SQL server, from the old version.