sql server dts: Need tools to Convert Access to SQL environment -- sql server dts

Need tools to Convert Access to SQL environment

guy NO[at]SPAM graphic-designer.com
11/28/2003 6:25:53 AM

sql server dts:

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,

Re: Need tools to Convert Access to SQL environment

Allan Mitchell
11/28/2003 2:51:09 PM

I don't know of any other tools than the ones you do not wnt to use. I dare
say they are out there. Why do you not want to use them ? DTS will only
take over tables and data nothing else.

You could write a big parsing routine to take your Access objects and
convert them to SQL Server but it could be very prone to difficulties.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]