Access to SQL2K5 - Selective Migration...

[Subbu]

Hi all,

I need to migrate Access tables to SQL Server 2005 (Structure and Data), but
only the selected ones and not all the tables from the access mdb.
Q1) What is a good way of doing this?
Q2) Any method that would allow me to reuse it later on, for example create
a script or something that would do the migration?
Q3) How best can SSIS be used here?

Thanks a lot
- Subbu
============

[Stefan Hoffmann]

hi,

Post by Subbu
I need to migrate Access tables to SQL Server 2005 (Structure and Data), but
only the selected ones and not all the tables from the access mdb.
Q1) What is a good way of doing this?

Using the built-in wizard in Access was always sufficent for me.

Post by Subbu
Q2) Any method that would allow me to reuse it later on, for example create
a script or something that would do the migration?
Q3) How best can SSIS be used here?

You may take a look at

http://www.microsoft.com/sql/solutions/migration/default.mspx


mfG
--> stefan <--

[Brent Spaulding (datAdrenaline)]

I like to do thing like this outside of wizard, so ... check out this thread
on utteraccess I participated in a while back. It has a procedure in it
that you can use to more just one table ...

http://www.utteraccess.com/forums/showflat.php?Number=1639193&fpart=all#Post1639193
--
Brent Spaulding | datAdrenaline | Access MVP

Post by Subbu
Hi all,
I need to migrate Access tables to SQL Server 2005 (Structure and Data), but
only the selected ones and not all the tables from the access mdb.
Q1) What is a good way of doing this?
Q2) Any method that would allow me to reuse it later on, for example create
a script or something that would do the migration?
Q3) How best can SSIS be used here?
Thanks a lot
- Subbu
============