EasyCFM.COM ColdFusion Forums / General Discussion / Access to MYsql

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Access to MYsql

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

cabry
03-02-2011 @ 1:13 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 94
Joined: Dec 2005

Hi we have had our sites connected up to access database and now want to convert them to Mysql or MS SQL. Does anyone have any ideas of some good software free or not which was can use to do this quickly.

Basically my boss has moved hosting companies and not checked before it went now most of our sites wont work as with the new company we can either use coldfusion or access and not both. So i need to convert them really quickly.

Thanks in advance

Webmaster
03-02-2011 @ 4:30 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Administrator
Posts: 4542
Joined: Jan 2002

If they are on access; you'd be best to use MS SQL. It
has a "upgrade" wizard to migrate your data and tables.

Once that is done; you will need to test your code. The
similarities are 95% the same.. but you will have some
differences.

You can reference them here:
http://sqlserver2000.databases.aspfaq.com/what-are-the-
main-differences-between-access-and-sql-server.html

Pablo Varando
Senior Application Architect
EasyCFM.COM, LLC.

904.483.1457 \\ mobile
webmaster@easycfm.com \\email

\m/ (>.<) \m/
--- rock on ---


Website Designed and Developed by Pablo Varando.