Installing a database with .db extension into SSMS

• michael.leach2015

  SSCommitted

  Points: 1597

  More actions

  April 21, 2019 at 1:03 am

  #3481467

  Is it possible to install a sample database with a .db extension into SQL server management studio?  I know how to install a database with a .bak extension but it's not working with the .db extension.

• Eirikur Eiriksson

  SSC Guru

  Points: 182947

  More actions

  April 21, 2019 at 9:31 am

  #3489991

  Can you please elaborate further on this? What are you trying to do? What is the source type of the .db file etc.

  

  SSMS does not host any databases or database files, those must reside on a SQL Server instance.

• Jeff Moden

  SSC Guru

  Points: 1004593

  More actions

  April 21, 2019 at 4:40 pm

  #3498348

  michael.leach2015 wrote:

  Is it possible to install a sample database with a .db extension into SQL server management studio?  I know how to install a database with a .bak extension but it's not working with the .db extension.

  ".db" isn't the normal extension for SQL Server databases.  What RDBMS did the ".db" files come from?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)