Difference between revisions of "Developing with MS SQL"
From MgmtWiki
(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
Contents
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.
