Hi experts

Could I ask some advice on migrating an MS Access mdb file to SQL Server.
The access database has about 50 table with relationships and I was hoping to
use either DTS or SSIS to do the bulk of the work.

I use the access database as a model/template for the larger system which
could be SQL Server, Oracle, DB2 etc.

I've heard DTS cannot retain the relationships (can SSIS?).
Would the access upsize wizard be the best way?

Thanks for any advice
J

jez123456 wrote:
Whilst I have never tried the SSIS Wizard for this, and doubt it will be
much better. Both tools are really aimed at moving data, and that is a
side effect of your primary goal, migrating structures. Feel free to
give both a quick try, and but I believe the Upsize Wizard would be a
better bet, or today's equivalent if that has changed to.

--
Darren
http://www.sqldts.com
http://www.sqlis.com

You might try reverse engineering your Access database using Visio and then
use Visio to create the structure in SQL Server. Then use SSIS to trasfer
the data.

"jez123456" wrote: