Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Upsizing from Access 2003 to SQL Express 2005 Expand / Collapse
Author
Message
Posted Thursday, January 3, 2008 2:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, January 5, 2008 7:15 PM
Points: 2, Visits: 3
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
Post #438278
Posted Friday, January 4, 2008 8:38 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, December 18, 2010 3:42 PM
Points: 103, Visits: 10,058
The Access wizard has short comings (duh). Microsoft has a better migration tool at http://www.microsoft.com/sql/solutions/migration/access/default.mspx .
Post #438988
Posted Friday, January 4, 2008 8:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 5:24 PM
Points: 7,139, Visits: 15,191
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?
Post #438995
Posted Saturday, January 5, 2008 7:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, January 5, 2008 7:15 PM
Points: 2, Visits: 3
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
Post #439286
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse