[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Convert MS Access db to MS SQL Server CE

Posted on 2009-02-10
3
Medium Priority
?
646 Views
Last Modified: 2013-11-26
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.
0
Comment
Question by:GIANTOCR
3 Comments
 
LVL 33

Accepted Solution

by:
jppinto earned 1000 total points
ID: 23598875
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
 
LVL 6

Assisted Solution

by:havj123
havj123 earned 1000 total points
ID: 23598909
0
 

Author Comment

by:GIANTOCR
ID: 23599333
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question