SSMA T-SQL

[Neville]

I would like to capture the T-SQL that SSMA generates to migrate an Access
table to SQL Server, b/c I would like to create a daily job to replicate the
migration in an automated fashion.

Any help?

Thx!

[Alex Dybenko]

Hi,
I think you can run sql server profiler, capture script and save it
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Post by Neville
I would like to capture the T-SQL that SSMA generates to migrate an Access
table to SQL Server, b/c I would like to create a daily job to replicate the
migration in an automated fashion.
Any help?
Thx!

[Mary Chipman [MSFT]]

Does the table have the same schema every day? If yes, then a better
approach would be to create an empty table on the server and
delete/load the data. Creating and dropping objects on the server has
more overhead than simply loading data.

--Mary

On Fri, 24 Jul 2009 07:12:01 -0700, Neville

Post by Neville
I would like to capture the T-SQL that SSMA generates to migrate an Access
table to SQL Server, b/c I would like to create a daily job to replicate the
migration in an automated fashion.
Any help?
Thx!