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