SQL Server LocalDB: Difference between revisions

From Yggenyk
Jump to navigation Jump to search
(Created page with 'Category:English pages Category:Software development * [http://www.sqlcoffee.com/SQLServer2012_0004.htm What is LocalDB? - SQLCoffee] * [http://msdn.microsoft.com/en-us/l…')
 
No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 3: Line 3:
* [http://www.sqlcoffee.com/SQLServer2012_0004.htm What is LocalDB? - SQLCoffee]
* [http://www.sqlcoffee.com/SQLServer2012_0004.htm What is LocalDB? - SQLCoffee]
* [http://msdn.microsoft.com/en-us/library/hh873188.aspx How to: Upgrade to LocalDB or Continue with SQL Server Express]
* [http://msdn.microsoft.com/en-us/library/hh873188.aspx How to: Upgrade to LocalDB or Continue with SQL Server Express]
* [http://forums.asp.net/t/1147899.aspx/1 How to import an mdf file into SQL Server Management Studio Express?]


* [http://www.istartedsomething.com/20121216/downloading-sql-express-2012-from-microsoft-com/ Downloading SQL Express 2012 from Microsoft.com]


* [http://en.wikipedia.org/wiki/SQL_Server_Compact SQL Server Compact - Wikipedia]
* [http://www.mssqltips.com/sqlservertip/2694/getting-started-with-sql-server-2012-express-localdb/ Getting Started with SQL Server 2012 Express LocalDB]
* [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]
====Connect to localdb using SQL Server Management Studio====
You need to run: '''CorFlags.exe /32BIT+  SqlCeEditor.exe''' to make ''SQL CE Database Editor'' run on x64 Windows.
Open SQL Server Management Studio and enter '''(LocalDB)\v11.0''' as Server name in the Connect to Server dialog.<br>
* [http://theruntime.com/blogs/brianpeek/archive/2007/11/13/x64-development-with-net.aspx CorFlags x64 Development with .NET]
You can now browse your LocalDB databases.  
* [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]
 
* [http://www.codeproject.com/Articles/20333/How-to-Restore-SQL-Server-2005-Suspect-Database How to Restore SQL Server 2005 Suspect Database]
[[File:SQL Server Management Studio - connect to LocalDB .png]]
* [http://www.informit.com/articles/article.aspx?p=776106 Getting to Know the SQL Server 2005 Compact Edition Tools]


<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"