Need tools to Convert Access to SQL environment

[Guy]

I got a big Access file (1 400 tables) to convert to SQL and I would
like to be provided with some automated tools, except upsizing wizard
and DTS, to convert it on my own.

I got a lot of forms and query to convert too.

Can someday provide me with at least one tool name ?

Thanks,

Guy

 

[Douglas J. Steele]

SQL Server is strictly a database: you can only convert your tables, because
it doesn't have forms or reports. (You can convert SELECT queries to views)

Tony Toews has some information about upsizing at
http://www.granite.ab.ca/access/sqlserverupsizing.htm including a link to a
tool from SSW.

 

[Guy]

SQL Server is strictly a database: you can only convert your tables, because
it doesn't have forms or reports. (You can convert SELECT queries to views)

Tony Toews has some information about upsizing at
http://www.granite.ab.ca/access/sqlserverupsizing.htm including a link to a
tool from SSW.

Thanks Douglas for your precious time and info.

I'm gonna read tyhe article and visit ssw site.

Guy