Skip to main content
C
cybertek23
Inspiring
March 1, 2011
Question

Access to MySQL or MS sql

  • March 1, 2011
  • 2 replies
  • 721 views

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

This topic has been closed for replies.

2 replies

D
Dan_Bracuk
Inspiring
March 2, 2011

There is more to it than that.

It's possible that some of your queries will no longer work because the syntax you used is not compatible with the new db software.  This is almost a certainty if you use any functions.

C
cybertek23Author
Inspiring
March 2, 2011
No text available
ilssac
ilssac
Inspiring
March 1, 2011

MS SQL being a Microsoft product just like Access actually has import utilities for Access built in.

But there are plenty of third party database utilities out there that would pretty much do any database management system to any database management system.

http://en.wikipedia.org/wiki/Comparison_of_database_tools

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices