Connection issues with the database after installing VS2013

Source: Internet
Author: User
Tags compact sql server express

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.