Developing with MS SQL

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

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Full Title

Helpful hints on using MS SQL on a development machine.



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.