Convert MS Access db to MS SQL Server CE

Posted on 2009-02-10
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.

Question by:GIANTOCR
    LVL 33

    Accepted Solution

    Hello GIANTOCR,

    Check to see if this can help you:


    LVL 6

    Assisted Solution


    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
    Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now