Migrate data from Access SQL 2005

9 Sep 2006 2:02 PM

mikepallorad

hello everybody

using the SSMA migration from Access 2003 to SQL 2005 is cool.

then Robert Burke saved me a lot of strain

http://blogs.msdn.com/robburke/archive/2006/05/30/610803.aspx

but i couldnt quiet understand the link to

"reproduce the data from your local tables on the remote server"

There are certain data in the Access database which are necessary
before running the
application.

what am trying to figure is how to use >> Script << to add these
"data" from Access to

SQL 2005 .

9 Sep 2006 2:11 PM

Mike C#

He points to this link in that article:
http://vyaskn.tripod.com/code.htm#inserts

The stored procedure there creates INSERT statements that you can run on SQL
Server.

<mikepallo***@ausi.com> wrote in message
Show quote

news:1157810571.953601.169500@i3g2000cwc.googlegroups.com...
> hello everybody
>
> using the SSMA migration from Access 2003 to SQL 2005 is cool.
>
> then Robert Burke saved me a lot of strain
>
> http://blogs.msdn.com/robburke/archive/2006/05/30/610803.aspx
>
> but i couldnt quiet understand the link to
>
> "reproduce the data from your local tables on the remote server"
>
> There are certain data in the Access database which are necessary
> before running the
> application.
>
> what am trying to figure is how to use >> Script << to add these
> "data" from Access to
>
> SQL 2005 .
>

9 Sep 2006 7:18 PM

Steve Dassin

QAlite is a free utility that will generate insert statements
and has many other features.

http://www.rac4sql.net/qalite_main.asp

best,
steve
http://racster.blogspot.com