Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Upsizing from Access 2003 to SQL Express 2005


Upsizing from Access 2003 to SQL Express 2005

Author
Message
Robin-596078
Robin-596078
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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
Perry Harts
Perry Harts
SSC-Enthusiastic
SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)SSC-Enthusiastic (105 reputation)

Group: General Forum Members
Points: 105 Visits: 10058
The Access wizard has short comings (duh). Microsoft has a better migration tool at http://www.microsoft.com/sql/solutions/migration/access/default.mspx .
Matt Miller (#4)
Matt Miller (#4)
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8257 Visits: 18251
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?
Robin-596078
Robin-596078
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search