Upsizing Access to SQL Server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Upsizing Access to SQL Server

Author

Topic

mcordewener
Starting Member

19 Posts

Posted - 2005-11-09 : 04:09:25

Hi There,

We need to upsize serveral MS Access DB's to SQL Server. Herefor we use the standard upsize wizard from MS.
However, this tool does not convert all query's and functions.
Expample.
An standard query with an inner join will nog be upsized because access uses an different SQL statement order.

Does anybody knows a good tool with wich we can easier upsize the DB's

greetz,

Marcel

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2005-11-09 : 04:16:47

Try out the following links if its helps..

http://www.convert-in.com/acc2mss.htm

Complicated things can be done by simple thinking

mcordewener
Starting Member

19 Posts

Posted - 2005-11-09 : 04:33:54

Thnx,

but this program only upsizes the tables, this works fine with the standard upsize from MS.

greetz,

Marcel

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources