|
Home > Archive > MS SQL Server DTS > March 2006 > Advice Please
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| jez123456 2006-02-08, 7:24 am |
| 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
| |
| Darren Green 2006-02-08, 1:23 pm |
| jez123456 wrote:
> 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
>
>
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
| |
| David Baldauff 2006-03-27, 8:27 pm |
| 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:
> 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
>
>
|
|
|
|
|