Saturday, February 13, 2016

SQL server express 2012 installation

SQL server express 2012 installation and use it in C# to test databinding and datagridview etc.

    installation process needs following steps:

    You can: Download SQL Server 2014 Express. Click the big red button that says "Download SQL Server 2012 Express" and choose the version you want. I am not certain what the differences are (after all I am only learning this myself), but I chose "Sql Server Express with Advanced Services" because it looked like it has everything one might need. So download it, install it and read on when you are done.

    Next thing you need to do is install a sample database for you to work with. It is probably best if you install the same database I am using, which is the AdventureWorks2012 sample database.

    Getting this was actually harder than installing SQL Server 2012. You can get it on the SQL Server Sample Database CodePlex website. At the time of this writing you can choose 14(!) downloads. What the...!? So I picked a few and got successful with the AdventureWorks2012-Full Database Backup.zip (near the bottom of list of downloads).

    after download the zip file and unzip the .bak file inside. Luckily here are the steps to get this into SQL Server. Place the .bak file in your SQL Server backup folder. If you have not changed anything during installation it should be in C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012EXPRESS\MSSQL\Backup. Now go to your SQL Server 2012 instance, open up the Object Explorer (if it is not opened already) and right click on the Database folder. In the context menu go to Restore Database.

    Click on "Device" and then click on the button behind it. You should now see the Select backup devices window. Click "Add" and browse to the .bak file you just unzipped (if you don't see it immediately). Select the .bak file and click "OK". Make sure you have no other files selected in the Select backup devices window. Click "OK" and you should be back in the Restore database window. You can review your options and click "OK" again. The AdventureWorks database should now be restored and ready for use.

    here are my statement: from Restore database page: select device option, then click Add button. From pop-up window, browse to backup folder and select .bak file.

  1. Adventure Works for SQL Server 2012
  2. Adventure Works 2014 Sample Databases
  3. AdventureWorks and Samples for SQL Server 2016 CTP
  4. Querying SQL Server 2012: Part I
  5. Querying SQL Server 2012: Part II
  6. SQL 2012 express installation guide

    this installation guide detailed the steps to follow, also it gave details how to configure it:

    For 32-Bit machines, download the file: SQLEXPRWT_x86_ENU.exe For 64-Bit machines, download the file: SQLEXPRWT_x64_ENU.exe

  7. Microsoft® SQL Server® 2012 Service Pack 1 (SP1) Express

    download SQL 2012 Express from this link by following the information on BillQuick guide.

  8. BillQuick Getting Started Guid
  9. it tells how to set up under different enviornments and how to set up database instances. good reference.

  10. How to Install SQL Server 2012 Express Edition
  11. Microsoft SQL Server Express: Version Comparison Matrix and Free Downloads
  12. SQL Server Express Forum
  13. Free eBooks from Microsoft Press for SQL Server and other Microsoft Products

  14. SQL 2016 server preview are coming..

  15. SQL Server 2016 Preview
  16. Editions and Components of SQL Server 2016

  17. Compare SQL server express vs. LocalDB version. with good user guide on LocalDB.

  18. Is there a difference between SQL Server Express (2012) and LocalDB?
  19. confusion about SQL Server Express and localdb
  20. SQL Express v LocalDB v SQL Compact Edition
  21. Introducing LocalDB, an improved SQL Express
  22. SQL Server 2012 connection strings

    a good connection string site to reference:

  23. Database Connectionstrings

    another good connection string site to reference:

  24. LocalDB Manager
  25. SQL Server Express LocalDB
  26. Getting Started with SQL Server 2012 Express LocalDB
  27. SQL Server 2012 Express LocalDB – How to get started
  28. How to Install SQL Server 2012 Express and SQL Server Management Studio 2012 Express :: youtube video

No comments:

Post a Comment