Converting Access to MS SQL

G

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.

I analysed a tool suggested by Douglas last week, but it convert only the data, and not the froms and query.
Click to expand...

Can someday provide me with other tool name ?
 
D

Douglas J. Steele

As I told you before, SQL Server doesn't have forms and queries in it: it's
a database only. Therefore it's impossible to find a product that will
convert your forms from Access to SQL Server, as there's nothing to convert
them to.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Guy said:
I got a big Access file (1 400 tables) to convert to SQL and I would
Click to expand...
the data, and not the froms and query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need tools to Convert Access to SQL environment 2
ANN: DBForms from MS Access to ASP.NET + MS SQL v 1.0 released. 0
After Upsizing 1
Queries missing in ADP and SQL after upsizing 4
Convert Access Macro to ASP code 1
Convert Access Queries to MSSQL 2
MS Access 2002 SQL to Oracle 9 PL/SQL 1
Upsizing wizard: run on web server or locally? 0

Top