How to: Upgrade to LocalDB or Continue with SQL Server Express
This topic describes your options for upgrading your database file (.mdf) after you install Visual Studio 2012 and includes instructions for the following tasks:
Upgrade a database file to use LocalDB Upgrade a database file to use a newer version of SQL Server Express Work with a database file in Visual Studio 2012 but retain compatibility with SQL Server 2008 Express Make SQL Server Express the default database engine
You can use Visual Studio 2012 to open a project that contains a database file (.mdf) that was created by using an older version of SQL Server Express. However, to continue to develop your project in Visual Studio 2012, you must either have that version of SQL Server Express installed on the same machine as Visual Studio, or you must upgrade the database file to use SQL Server Express
LocalDB. If you upgrade the database file, you won't be able to access it with older versions of SQL Server Express.
You may also be prompted to upgrade a database file that was created by using SQL Server 2012 Express if the version of the file isn't compatible with the instance of SQL Server Express that’s currently installed. To resolve the issue, Visual Studio will prompt you to upgrade the file to the newer version of SQL Server Express. Important We recommend that you back up the database file before you upgrade it. Before you upgrade a database, you should consider the following criteria:
Don't upgrade if you want to work on your project in both Visual Studio 2010 and Visual Studio 2012. Don't upgrade if your application will be used in environments that use SQL Server Express rather than LocalDB. Don't upgrade if your application uses remote connections because LocalDB doesn't accept them. Don't upgrade if your application relies on Internet Information Services (IIS). Consider upgrading if you want to test database applications in a sandbox environment but don't want to administer a database.
To upgrade a database file to use LocalDB
1. In Server Explorer, choose the Connect to Database button.
2. In the Add Connection dialog box, specify the following information:
o Data Source: Microsoft SQL Server (SqlClient)
o Server Name: (LocalDB)\v11.0
o Attach a database file: Path, where Path is the physical path of the primary .mdf file. o Logical Name: Name, where Name is the name that you want to use with the file.
3. Choose the OK button.
4. When prompted, choose the Yes button to upgrade the file.
The database is upgraded, attached to the LocalDB database engine, and no longer compatible with SQL Server 2008 Express.
如何打升级_金融/投资_经管营销_专业资料。升级是国内非常盛行的一种 4 人扑克牌游戏,可以选择一副牌、两副牌或者三副牌进行。打一副牌 时,也称为 "40 分...
如何升级到win10_电脑基础知识_IT/计算机_专业资料。尽管 Win10 正式版还需要等到 2015 年上半年,但是 Win10 预览版已经可以下载安装 了,其体验和正版相差不大...
QQ怎么在线升级_电脑基础知识_IT/计算机_专业资料。腾讯QQ聊天,教程,办公,应用,技巧QQ 怎么在线升级出处:电脑百事网时间:2012-11-07 人气:1939 我来评论 相关...
网友教您如何自己动手升级笔记本内存_IT/计算机_专业资料。笔记本内存升级,有图,详细网友教您如何自己动手升级笔记本内存 2010年12月15日01:44IT168我要评论(0...
教你怎么升级导航地图_天文/地理_自然科学_专业资料 暂无评价0人阅读0次下载举报文档 教你怎么升级导航地图_天文/地理_自然科学_专业资料。...
英雄联盟怎么升级快_计算机硬件及网络_IT/计算机_专业资料。英雄联盟升级方法英雄联盟怎么升级方法揭秘 lol 快速升级三倍经验刷电脑 好吧,现在已经有很多人到 30 ...
QQ升级如何计算_信息与通信_工程科技_专业资料。QQ等级的介绍欢迎访问我的百度空间喔: http://hi.baidu.com/zaq小北 腾讯公司将于2005年8月15日推出新的QQ...
e道航如何升级_信息与通信_工程科技_专业资料。e道航 升级e 道航 喊你 回家 升级 老用 户回 馈活 动 http://www.dayoo.com/ 2010-07-15 21:24 来源...
这次巴士三星小编 整理出 2.3.4 安卓手机系统升级教程,同样适用其它的安卓系统升级哦,现在大 家就请看下面的介绍吧。 安卓系统怎么升级很多人都有此疑问,而...
路由器怎么升级 鲜为人知的路由器升级方法有时候我们希望路由器能够使用一些新功能或者希望路由器更稳定可以采用路由器升级,那么 路由器怎么进行升级呢, 这个问题相信...
热门文档