Upsizing from Access 2003 to SQL Express 2005

  • This is a long story.

    A few weeks ago I installed SQL Express 2005 on my Vista machine and had everything working well. The upsizing went fine and I found that I really liked the SQL from 2005, unlike the rubbish I've had to put up with the Jet engine - I love the ANSI standard that I used to work with in Oracle.

    Because I have been experimenting for work on placing existing Access databases serverside due to an expected fleet upgrade and rollout to Vista, I also installed Oracle's 11j and experienced all sorts of problems. Eventually, I scrubbed the C: drive and made it into a dual boot with XP on one partition (for Oracle) and Vista on another (for SQLExpress 2005). Since then, I cannot get an Access database to upsize. The Upsizing Wizard Report tells me the tables were skipped or the export failed. Nothing is created in Express, no tables, views, procedures etc. No database at all!

    The weird thing is that I can create databases in Express and have the demo AdventureWorks there to prove it, I can create an Access .adp project linked to Express and have created an ODBC connection between the two that works fine. It's just that the upsizing will not work.

    Please help.

    Thanks

    Robin

  • The Access wizard has short comings (duh). Microsoft has a better migration tool at http://www.microsoft.com/sql/solutions/migration/access/default.mspx .

  • There are also several occasions where data types are slightly different and would cause things to fail. date fields in particular.

    If the migration assistant Perry pointed out doesn't help - try using SSIS to pull the data in, rather than using the upsizing wizard to push the data over. You should at least get some better error messages

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • Thanks for the prompt replies. I fixed the problem by getting rid of the dual boot, reinstalled Vista and all is now perfect. The upsizing works fine as well as everything else.

    Once again, thanks for the assistance.

    Robin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply