Difference between revisions of "Developing with MS SQL"

From MgmtWiki
Jump to: navigation, search
(Created page with "==Full Title== Helpful hints on using MS SQL on a development machine. ==Context== ==Issues== ==References== Category:Best Practice")
 
(SQL Server Express LocalDB)
 
(2 intermediate revisions by the same user not shown)
Line 4: Line 4:
  
 
==Issues==
 
==Issues==
 +
===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
 +
*(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.
 +
===SQL Server Express===
 +
On the other hand SQL Server Express is free and has most of the necessary functions for a medium scale deployment and can work well in a development environment.
  
 
==References==
 
==References==
  
 
[[Category:Best Practice]]
 
[[Category:Best Practice]]

Latest revision as of 21:16, 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.

SQL Server Express

On the other hand SQL Server Express is free and has most of the necessary functions for a medium scale deployment and can work well in a development environment.

References