Re: Fwd: Best way to get Access DB structures into MySQL ??

[Chris Martin]

GH wrote:
-- Forwarded message --
From: GH <[EMAIL PROTECTED]>
Date: Sun, 12 Sep 2004 02:49:02 -0400
Subject: Re: Best way to get Access DB structures into MySQL ??
To: Chris Martin <[EMAIL PROTECTED]>
Does this also allow for the importation of the data as well?

On Sat, 11 Sep 2004 21:34:33 -0700, Chris Martin <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote:
What is the best way to take the structure of multiple tables in Access
and get them re-created in MySQL without doing that all by hand?

Is there a way to do the equivalent of a Show Create Table in Access, that
I could then use in MySQL ??

Chris Hood
Investigator Verizon Global Security Operations Center
Email:  <mailto:[EMAIL PROTECTED]>
[EMAIL PROTECTED]
Desk: 972.399.5900
Verizon Proprietary
MySQL-Front has an ODBC import feature.
The old 2.5 version was free (looks like it still is)
http://www.bumpersoft.com/Programming/Databases_and_Networks/Review_982_index.htm
It's since been taken over by new developers, and newer versions are
available for a reasonable fee at
http://www.mysqlfront.de/download.html
--
Chris Martin
Web Developer
Open Source & Web Standards Advocate
http://www.chriscodes.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Yes, It does.
--
Chris Martin
Web Developer
Open Source & Web Standards Advocate
http://www.chriscodes.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fwd: Best way to get Access DB structures into MySQL ??

[GH]

-- Forwarded message --
From: GH <[EMAIL PROTECTED]>
Date: Sun, 12 Sep 2004 02:49:02 -0400
Subject: Re: Best way to get Access DB structures into MySQL ??
To: Chris Martin <[EMAIL PROTECTED]>

Does this also allow for the importation of the data as well?




On Sat, 11 Sep 2004 21:34:33 -0700, Chris Martin <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> > What is the best way to take the structure of multiple tables in Access
> > and get them re-created in MySQL without doing that all by hand?
> >
> >
> >
> > Is there a way to do the equivalent of a Show Create Table in Access, that
> > I could then use in MySQL ??
> >
> >
> >
> > Chris Hood
> >
> > Investigator Verizon Global Security Operations Center
> >
> > Email:  <mailto:[EMAIL PROTECTED]>
> > [EMAIL PROTECTED]
> >
> > Desk: 972.399.5900
> >
> > Verizon Proprietary
>
> MySQL-Front has an ODBC import feature.
>
> The old 2.5 version was free (looks like it still is)
> http://www.bumpersoft.com/Programming/Databases_and_Networks/Review_982_index.htm
>
> It's since been taken over by new developers, and newer versions are
> available for a reasonable fee at
> http://www.mysqlfront.de/download.html
>
> --
> Chris Martin
> Web Developer
> Open Source & Web Standards Advocate
> http://www.chriscodes.com/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Best way to get Access DB structures into MySQL ??

[Chris Martin]

[EMAIL PROTECTED] wrote:
What is the best way to take the structure of multiple tables in Access
and get them re-created in MySQL without doing that all by hand? 

 

Is there a way to do the equivalent of a Show Create Table in Access, that
I could then use in MySQL ??
 

Chris Hood 

Investigator Verizon Global Security Operations Center 

Email:  
[EMAIL PROTECTED] 

Desk: 972.399.5900
Verizon Proprietary
MySQL-Front has an ODBC import feature.
The old 2.5 version was free (looks like it still is)
http://www.bumpersoft.com/Programming/Databases_and_Networks/Review_982_index.htm
It's since been taken over by new developers, and newer versions are 
available for a reasonable fee at
http://www.mysqlfront.de/download.html

--
Chris Martin
Web Developer
Open Source & Web Standards Advocate
http://www.chriscodes.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Best way to get Access DB structures into MySQL ??

[Martijn Tonies]

Download yourself the trial version of Database Workbench
at www.upscene.com and try the Schema Migration tool.
Connect to Access via ADO and migrate the existing structure
to MySQL.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com



What is the best way to take the structure of multiple tables in Access
and get them re-created in MySQL without doing that all by hand?



Is there a way to do the equivalent of a Show Create Table in Access, that
I could then use in MySQL ??







Chris Hood

Investigator Verizon Global Security Operations Center

Email:  
[EMAIL PROTECTED]

Desk: 972.399.5900

Verizon Proprietary







-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Best way to get Access DB structures into MySQL ??

[Peter Brawley]

Christopher,

>What is the best way to take the structure of multiple tables in Access
>and get them re-created in MySQL without doing that all by hand?

>Is there a way to do the equivalent of a Show Create Table in Access, that
>I could then use in MySQL ??

The only way I know is to use a tool like Dezign or DbScripter to generate a
script.

PB

Best way to get Access DB structures into MySQL ??

[christopher . l . hood]

What is the best way to take the structure of multiple tables in Access
and get them re-created in MySQL without doing that all by hand? 

 

Is there a way to do the equivalent of a Show Create Table in Access, that
I could then use in MySQL ??

 

 

 

Chris Hood 

Investigator Verizon Global Security Operations Center 

Email:  
[EMAIL PROTECTED] 

Desk: 972.399.5900

Verizon Proprietary