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,

Subbu wrote:
> 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.

> 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

"Subbu" <Su...@discussions.microsoft.com> wrote in message
news:3F5C406D-7775-4CCD...@microsoft.com...