CODEWITHSUNDEEP
sqldatabasems-accessphpmyadmin
john
john

Reputation:

How to convert an Access database to SQL?

I want to convert my Access database to SQL because my host only supports importing a database through SQL in their phpmyadmin.

Upvotes: 2

Views: 12786

Answers (8)

Vinay Pandey
Vinay Pandey

Reputation: 8913

You may like to give a try to the migration tool(http://support.microsoft.com/kb/237980)

Upvotes: 0

James Sinclair
James Sinclair

Reputation: 407

IMHO the best way to do this is a combination of some/most of the posted answers.

download an express version of SQL server and get it running on your PC. download SSMA (SQL Server Migration Assistant) from http://www.microsoft.com/sqlserver/en/us/product-info/migration.aspx

this handles the various changes to datatypes that you may/may not require.

then once thats migrated everything over you'll be free to connect to your SQL server epxress instance from phpMyAdmin

I'm actually doing some contract work atm migrating Access DB's to SQL and this is the route I took and found it to be very straight forward and robust

Upvotes: 0

winwaed
winwaed

Reputation: 7801

Do you mean MySQL? Which is a database implementation. 'SQL' is a language used for querying and modifying relational databases. Microsoft Access supports the SQL language. Like most stnadards, the SQL standard has different implementations on different database systems!

Upvotes: 0

jkndrkn
jkndrkn

Reputation: 4062

I've used Bullzip Access To MySQL on two separate projects and found it to be quite solid and reliable.

Upvotes: 2

aduric
aduric

Reputation:

What version of Access are you using? You will need to export all the Access tables to CSV files and import each one into mySQL. There might be tools that automatically do that now, but they could screw up your data or ay PK and FK mappings you have. Best way IMO to do it table-by-table to ensure data integrity.

Upvotes: 1

Slartibartfast
Slartibartfast

Reputation: 8805

Because DB on your server is MySQL, I would:

  1. install MySql on local machine
  2. connect ODBC to MySQL DB
  3. from access open MySQL database (as ODBC resource) and copy data to it
  4. export data from MySQL

It's long way round, but it's most likely to work properly.

Upvotes: 2

kevchadders
kevchadders

Reputation: 8335

Download something like SQL Server 2005 Express, which is free to use, and import it into there, then generate the SQL

http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx

Upvotes: 3

achinda99
achinda99

Reputation: 5078

Hmm, I don't think Access has the ability to generate SQL for creating its tables and data. What I can suggest is importing it into SQL Server (any version should do) and then use SQL Server to generate the create table and data scripts.

Upvotes: 3

Related Questions