bangers3474
asked on
convert access db to mysql db through phpmyadmin
I am trying to convert an access database to a MySql database held on a remote ISP.
The ISP doesn't allow remote access to the MySQL database but I do have phpMyAdmin installed and linked to the MySQL database (completely empty, no table, queries or data).
As remotely linking to the SQL db from my pc isn't possible is there a way I can do this through myPHPAdmin or is there another way?
Any help greatley appreciated,
Bnager
P.S it isn't so much the data held within the tables I'm worried about more the tables themslves plus their relationships and queries which I would like to convert to the mysql format.
The ISP doesn't allow remote access to the MySQL database but I do have phpMyAdmin installed and linked to the MySQL database (completely empty, no table, queries or data).
As remotely linking to the SQL db from my pc isn't possible is there a way I can do this through myPHPAdmin or is there another way?
Any help greatley appreciated,
Bnager
P.S it isn't so much the data held within the tables I'm worried about more the tables themslves plus their relationships and queries which I would like to convert to the mysql format.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>Sounds like a DTC Package might be the way to go as the phpmyadmin tool isn't something I'm overley familiar with.
>>Does anyone know of a particularly good one (preferablyinexpensive).
DTC is a feature of Microsoft SQL Server 2000, and thus very expensive! You need an instance of SQL Server to do this with.
Alain34's idea of doing it localy might help.
>>Does anyone know of a particularly good one (preferablyinexpensive).
DTC is a feature of Microsoft SQL Server 2000, and thus very expensive! You need an instance of SQL Server to do this with.
Alain34's idea of doing it localy might help.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Does anyone know of a particularly good one (preferablyinexpensive).
Regards
Bangers