After installing VB2013, a SQL Server Express LocalDB is installed automatically , and the previous version of 2013 installs SQL Server Express, which has the following differences:
Http://www.cnblogs.com/shanyou/archive/2012/09/05/2672590.html
Soft new SQL Server Express LocalDB is a running mode for SQL Server, ideal for use in development environments and built into Visual Studio 2012.
about the SQL Server Express LocalDB Mode of Operation
The minimum file required for a SQL Server Express instance is copied when LocalDB is installed, basically LocalDB is almost identical to the full SQL Server Express Database engine, and SQL Server D is started LocalDB way Atabase Engine instances have the same limitations as SQL Server Express (because they share the same files as SQL Server Express), but LocalDB has more than SQL Server Express because it simplifies administration Some limitations, but these limits usually do not affect development. Compared to the older version of SQL Server Express, there are some differences between the two: after installing SQL Server Express LocalDB, there is an instance named v11.0
Before you can create a new LocalDB instance, you must understand the path to the SqlLocalDB.exe tool program, refer to the following path:
C:\Program Files\Microsoft SQL Server\110\tools\binn\sqllocaldb.exe
The following is an instruction to establish an LocalDB instance where "localdbtest" is the name of the instance you are able to name yourself:
SqlLocalDB.exe Create localdbtest
We then use the command to list all the instances that LocalDB has established and to view information about the specific instance:
SqlLocalDB.exe Info
SqlLocalDB.exe Info Projects
Entering the directory will see these system database files, error records, record tracking, encryption keys as well as the full version of SQL Server 、... And so on, as shown:
SQL Server Express LocalDB with other SQL Server Comparison of versions
Prior to the advent of SQL Server 2012, SQL Server had different versions depending on the operating environment, with different restrictions on running, such as:
- SQL Server Enterprise for large data or high availability environments
- SQL Server Standards (Standard Edition, suitable for use in general database processing environments)
- SQL Server Express (lightweight, suitable for use in single-or small-scale database environments)
- SQL Server Compact (lite, also known as SQL CE, for mobile or embedded system environments)
And what kind of a location is SQL Server Express LocalDB? The complexity of the database system has been reordered as follows:
- SQL Server Enterprise > Standard > Express > LocalDB > Compact
Because SQL Server Express LocalDB is similar to SQL Server R2 Express in front edition, the limitations are:
- The LocalDB instance collation defaults to SQL_Latin1_General_CP1_CI_AS and cannot be changed.
However, database hierarchy , data row level , and expression level sequencing are supported.
In other words, you can simply specify its collation when you build the database , or mount a database file that is moved by another database system, or restore a backup file from another database.
Autonomous databases follow the metadata defined by autonomous database sequencing and the tempdb sequencing rules.
The connection string in VS is as follows:
Data source= (localdb) \projects;initial catalog=test;integrated security=true; Connect timeout=30; Encrypt=false; Trustservercertificate=false
where (LocalDB) \projects is Servername,catalog is the database name.
Connection issues with the database after installing VS2013