How can I convert an existing MS Access database to an existing SQL Server Compact Edition database?

Question

I created an application powered by MS Access with two tables and about 30 rows of records. I eventually re-worked the C# application to run off SQL Server CE for more record space and security. How can I migrate that data to the new database?

Answer 1

Microsoft has a conversion software for that for Access 97-2003 DBs.

Access 2007 has it built right in!



But if all your converting is the data & tables (not the queries and scripts) You should be able to dump the table to a .CSV and have SQL pick up the file and build it's table out of that...

Answer 2

Um...just guessing here. Since SQL is a cross platform compatible language, can't you just export the SQL statements out of Access to create the tables and insert the data into SQL SCE?

Answer 3

Right click your table name > "Script Table as" > CREATE To > New Query Editor Window Open the new database in Access.

Answer 4

I forgot to give you the link to the data migration info page. If you look on the right hand side of the page, you'll see the data sheets. http://www.emanio.com/DataMigration.html