Difference between revisions of "Developing with MS SQL"

From MgmtWiki
Jump to: navigation, search
(Issues)
(SQL Server Express LocalDB)
Line 6: Line 6:
 
===SQL Server Express LocalDB===
 
===SQL Server Express LocalDB===
 
* [https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-2017 SQL Server Express LocalDB] is installed with Visual Studio to make it easier to bring up a test environment without worrying much about the database. It will look like this in the SQL Server Object Explorer tab on Visual Studio
 
* [https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-2017 SQL Server Express LocalDB] is installed with Visual Studio to make it easier to bring up a test environment without worrying much about the database. It will look like this in the SQL Server Object Explorer tab on Visual Studio
*(localdb)\MSSQLLocalDB(SQL ...)
+
*(localdb)\MSSQLLocalDB(SQL Server...)
Warning, this simple instance may work well with a simple ASP.NET development, but will not work will with more complex configurations.
+
Warning, this simple instance may work well with a simple ASP.NET development, but will not work will with more complex configurations. Check the above link for details.
  
 
==References==
 
==References==
  
 
[[Category:Best Practice]]
 
[[Category:Best Practice]]

Revision as of 21:14, 28 July 2020

Full Title

Helpful hints on using MS SQL on a development machine.

Context

Issues

SQL Server Express LocalDB

  • SQL Server Express LocalDB is installed with Visual Studio to make it easier to bring up a test environment without worrying much about the database. It will look like this in the SQL Server Object Explorer tab on Visual Studio
  • (localdb)\MSSQLLocalDB(SQL Server...)

Warning, this simple instance may work well with a simple ASP.NET development, but will not work will with more complex configurations. Check the above link for details.

References