Visual Studio 2008 really places a lot of emphasis on SQL Server Compact.ÃÂ I recently tried it out for a course project in Information Visualization.ÃÂ I had some existing data I needed to visualize that was in Access Jet (MDB) format, which I wanted to copy into a new SDF file.ÃÂ This should have been extremely straightforward to do, but it actually turned out to be a nightmare.
For comparison, I also have SQL Server Express 2008 installed, as well as Microsoft Access 2007.ÃÂ To transfer a database from an MDB file to SQL Server Express 2008, I could do any
of the following:
- Start Access 2007.ÃÂ Open the MDB file.ÃÂ Click the "External Data" ribbon.ÃÂ In the "Export" group, click "More", and click "ODBC database".ÃÂ Select the DSN for SQL Server Express 2008.ÃÂ Continue following the wizard.
- Start Access 2007.ÃÂ Open the MDB file.ÃÂ Click the "Database Tools" ribbon.ÃÂ
In the "Move Data" group, click "SQL Server".ÃÂ Follow the wizard.
- Start the SQL Server Import and Export Wizard (a.k.a. DTS).ÃÂ For "Data Source", choose "Microsoft Access" and select the file.ÃÂ For "Destination", select from any of these three choices and choose the appropriate options: