Convert MS Access db to MS SQL Server CE

I am using Visual Studio 2005 to build a mobile application. I would like to add a SQL Server CE database to the project that has the same structure (tables and relations) as an existing MS Access 2000 database. Is there a way to do this without having to manual recreate it all.

Thanks.
GIANTOCRAsked:
Who is Participating?
 
jppintoConnect With a Mentor Commented:
Hello GIANTOCR,

Check to see if this can help you:

http://stackoverflow.com/questions/481719/import-access-data-into-sql-server-ce-mdb-to-sdf


Regards,

jppinto
0
 
GIANTOCRAuthor Commented:
havj123 and jppinto, thank you for your prompt responses. It will be this evening before I can try these out. I will do so and award points then.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.