SQL Server LocalDB: Difference between revisions

From Yggenyk
Jump to navigation Jump to search
No edit summary
No edit summary
 
(4 intermediate revisions by the same user not shown)
Line 5: Line 5:
* [http://forums.asp.net/t/1147899.aspx/1 How to import an mdf file into SQL Server Management Studio Express?]
* [http://forums.asp.net/t/1147899.aspx/1 How to import an mdf file into SQL Server Management Studio Express?]


* [http://en.wikipedia.org/wiki/SQL_Server_Compact SQL Server Compact - Wikipedia]
* [http://www.istartedsomething.com/20121216/downloading-sql-express-2012-from-microsoft-com/ Downloading SQL Express 2012 from Microsoft.com]
* [http://support.x-tensive.com/question/1771/sql-compact-edition Referencing an older version of SQL Server Compact]
 
* [http://sqlcedatabaseeditor.codeplex.com/ SQL CE Database Editor  - CodePlex]
* [http://www.mssqltips.com/sqlservertip/2694/getting-started-with-sql-server-2012-express-localdb/ Getting Started with SQL Server 2012 Express LocalDB]
You need to run: '''CorFlags.exe /32BIT+  SqlCeEditor.exe''' to make ''SQL CE Database Editor'' run on x64 Windows.
 
* [http://theruntime.com/blogs/brianpeek/archive/2007/11/13/x64-development-with-net.aspx CorFlags x64 Development with .NET]
====Connect to localdb using SQL Server Management Studio====
* [http://gargmanoj.wordpress.com/2008/07/17/how-to-repair-a-sql-server-2005-suspect-database/ How to repair a SQL Server 2005 Suspect database]
Open SQL Server Management Studio and enter '''(LocalDB)\v11.0''' as Server name in the Connect to Server dialog.<br>
* [http://www.codeproject.com/Articles/20333/How-to-Restore-SQL-Server-2005-Suspect-Database How to Restore SQL Server 2005 Suspect Database]
You can now browse your LocalDB databases.
* [http://www.informit.com/articles/article.aspx?p=776106 Getting to Know the SQL Server 2005 Compact Edition Tools]
 
[[File:SQL Server Management Studio - connect to LocalDB .png]]


<google>ENGELSK</google>
<google>ENGELSK</google>

Latest revision as of 11:08, 12 August 2014

Connect to localdb using SQL Server Management Studio

Open SQL Server Management Studio and enter (LocalDB)\v11.0 as Server name in the Connect to Server dialog.
You can now browse your LocalDB databases.

SQL Server Management Studio - connect to LocalDB .png

<google>ENGELSK</google>

id=siteTree

Retrieved from "http://yggenyk.dk/index.php?title=SQL_Server_LocalDB&oldid=7421"