[AccessD] Upsize wizard MDB to SQL

Erwin Craps - IT Helps Erwin.Craps at ithelps.be
Tue Apr 5 07:04:45 CDT 2005


 
I need to migrate a MDB front and back to SQL server.
 
I tried the both the upsize wizard in MSA2K3 and the import wizard from
SQL server 2000.
But I found out that a lot of stuff are not migrated and renders the
application in a non useable state.
In some cases all the queries are missing, or primary keys and relations
are not set, to much various things missing to verify manualy.
 
I wonder if a commercial tool exists to do a better upsize that will
leave my database in a more or less workable state?
 
Personaly I would prefer a parralel migration.
 
All data in sql server, still using the regular front end but linked
tables to sql and first migrate my IIS-ASP website to .NET and later on
the (multiple) front end MDB.
 

 

Erwin Craps

Zaakvoerder 

www.ithelps.be/onsgezin

 

This E-mail is confidential, may be legally privileged, and is for the
intended recipient only. Access, disclosure, copying, distribution, or
reliance on any of it by anyone else is prohibited and may be a criminal
offence. Please delete if obtained in error and E-mail confirmation to
the sender.

IT Helps - I.T. Help Center  ***  Box Office Belgium & Luxembourg

www.ithelps.be <http://www.ithelps.be/>   *  www.boxoffice.be
<http://www.boxoffice.be/>   *  www.stadleuven.be
<http://www.stadleuven.be/> 

IT Helps bvba* ** Mercatorpad 3 **  3000 Leuven

IT Helps  *  Phone: +32 16 296 404  *  Fax: +32 16 296 405 E-mail:
Info at ithelps.be 

Box Office **  Fax: +32 16 296 406 **  Box Office E-mail:
Staff at boxoffice.be <mailto:figures at boxoffice.be> 

 



More information about the AccessD mailing list