Can SQL Server 2008 access Northwind or Pubs databases? [Archive]

View Full Version : Can SQL Server 2008 access Northwind or Pubs databases?

BobLewiston

03-13-2009, 01:55 AM

I've installed SQL Server 2008 Express with Advanced Features, but I've been having so-far insurmountable problems installing the AdventureWorks sample databases. However, I've successfully installed the Northwind sample databases, and I've downloaded the installer for the Pubs sample databases, so:

Can SQL Server 2008 access Northwind or Pubs databases?

Old Pedant

03-13-2009, 02:07 AM

What KIND of databases are they???

If they are ".mdb" (Access) files, then SQL Server is the wrong tool to use.

If they are ".dbf" files or if you installed by importing into a SQL Server DB, then of course you can use SQL Server to access them.

BobLewiston

03-13-2009, 02:38 AM

Old Pedant:

The Northwind files I've already installed are ".mdb" files. I haven't installed the Pubs databases yet so I don't know what they are.

Do you know if there's any way to import ".dbf" files into a SQL Server DB?