Developing with MS SQL

From MgmtWiki
Revision as of 22:14, 28 July 2020 by Tom (talk | contribs) (SQL Server Express LocalDB)

Jump to: navigation, search

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