Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    173

    Unanswered: Moving an Existing mdb to mdf

    How would you go about moving a database structure - tables and relations and data to an instance of sql server express?

  2. #2
    Join Date
    Nov 2005
    Posts
    20
    Programming/Web Design
    http://eofficeprofessionals.com/forums

    Offer solutions-not criticism.

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Have a look athe upsizing wizard

    Tools | Database Utilities | Upsizing Wizard

    a word of caution the wizard can do most of the work in transferring info into SQL server it doens't neccesarily do the complete process.

    However the biggest potential issue is that if you move an existing app into SQL server: is that often the application isn't rewritten to take advantage of the server back end. I notice that you merely want to move the tables & data but if you are planning on using an existing application you need to think carefully about rewriting your app to leverage the power of the server backend

    HTH

  4. #4
    Join Date
    Dec 2007
    Posts
    1
    show me the topic

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •