Transfer database to MySQL.Huge effort?

--_c5ccd5ef-1569-4c56-9514-f2a49e368bbb_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


I want to transfer a database(not MySQL) to MySQL(only the tables=2Cnot sto=
red procedures=2Cviews etc.).Using SQLWays I gotseveral problems(It needs s=
ome expertise).Now using SQLMaestro DataWizard I exported some tables to cs=
v format forimporting with mysqlimport=2CI previously created the database =
with CREATE DATABASE (database in simpliest form).Now=2Cwhen I use mysqlimp=
ort to import the csv formatted tables it tells that I do not have the tabl=
e xyz.I thought themysqlimport command could automatically read the importe=
d file and create the table with adequate structure and name according to t=
he read/imported file.The number of tables to import are almost two hundred=
and previously creating in MySQL almost two hundred tableswith structure c=
ompatible to the imported database tables is a huge effort.Are there any ea=
sier method to follow?I am a relatively new user of database software.
=
Thanks.
=

--_c5ccd5ef-1569-4c56-9514-f2a49e368bbb_--

Re: Transfer database to MySQL.Huge effort?

Luis,

I regularly move data from MSSQL to MySQL using Navicat. Start MSSQL (the
lite version is free if you don't have it) and load your MSSQL data. From
Navicat, create a database to receive the data and import it using ODBC.

Very slick, reasonably quick, complete transfer including creating the
tables.

Thanks,

Carl

----- Original Message -----
From: "Luis Suzuki"
To:
Sent: Saturday, September 18, 2010 6:59 PM
Subject: Transfer database to MySQL.Huge effort?



I want to transfer a database(not MySQL) to MySQL(only the tables,not stored
procedures,views etc.).Using SQLWays I gotseveral problems(It needs some
expertise).Now using SQLMaestro DataWizard I exported some tables to csv
format forimporting with mysqlimport,I previously created the database with
CREATE DATABASE (database in simpliest form).Now,when I use mysqlimport to
import the csv formatted tables it tells that I do not have the table xyz.I
thought themysqlimport command could automatically read the imported file
and create the table with adequate structure and name according to the
read/imported file.The number of tables to import are almost two hundred and
previously creating in MySQL almost two hundred tableswith structure
compatible to the imported database tables is a huge effort.Are there any
easier method to follow?I am a relatively new user of database software.

Thanks.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Transfer database to MySQL.Huge effort?

Hello,

Basically you need to do it manually, no auto import tool will get things
100%

1. create tables, substituting datatypes from source database to compatible
mysql (especially the integer types)
2. create keys that will give same result
3. pump the data, you might have to write scripts to do on the fly
conversion instead of direct export import
4. test the data?

How are you planning to implement the stored procedure if you are not going
to move them?

otherwise

if you are willing to pay, I bet there are companies that do this :)

Jangita | +254 76 918383 | MSN & Y!: jangita@yahoo.com
Skype: jangita | GTalk: jangita.nyagudi@gmail.com



-----Original Message-----
From: Luis Suzuki [mailto:luissuzuki@live.com]
Sent: 19 September 2010 12:59 AM
To: mysql@lists.mysql.com
Subject: Transfer database to MySQL.Huge effort?


I want to transfer a database(not MySQL) to MySQL(only the tables,not stored
procedures,views etc.).Using SQLWays I gotseveral problems(It needs some
expertise).Now using SQLMaestro DataWizard I exported some tables to csv
format forimporting with mysqlimport,I previously created the database with
CREATE DATABASE (database in simpliest form).Now,when I use mysqlimport to
import the csv formatted tables it tells that I do not have the table xyz.I
thought themysqlimport command could automatically read the imported file
and create the table with adequate structure and name according to the
read/imported file.The number of tables to import are almost two hundred and
previously creating in MySQL almost two hundred tableswith structure
compatible to the imported database tables is a huge effort.Are there any
easier method to follow?I am a relatively new user of database software.

Thanks.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org