visitor (0 QPoints)
  • FR
  • EN
  • NL
  • DE
  • ES
294 experts, 1172 registered users, 1625 questions already answered
European Experts Exchange, the very best site for high-quality IT solutions

New Improved Search!

 


The DDRK link is back online.
We got a one week service interruption, sorry.
(23-30/01/2010)

Databases :: MySql :: How to convert MS SQL 2000 Table structure to MySQL Table Structure
By: Bernard France  Date: 15/11/2004 08:56:40  English French  Points: 70 Status: Answered
Quality : Excellent
We have a database in ms sql server 2000. I want to convert ms sql server 2000 tables into mysql tables.
any free tools available in net for this. Or..anyother way to this conversion ?
By: VGR Date: 15/11/2004 09:01:01 English  Type : Answer
a part from the "identity" non-portable non-standard attribute of M$-$ql-$erver being translated to an "integer unique auto_increment", I see no reason why it shouldn't work almost right out.

Just give it a try and come back here with precise errors...

You main concern will be if you used non-standard datatypes. If you used SQL-compliant datatypes, then your only minor concern will be with the MySql limitations of some fields (authorized by the SQL standard), for example a VARCHAR(4000) isn't allowed. This would be TEXT.

If you would like tools to perform this for you, I see two solutions :
1) SQLPorter might be a tool can do for you, please read this

http://www.mysql.com/portal/software/item-124.html

2) if you don't have too many tables, in the package of mssql 2000 is an import/export-tool, which uses oledb, to import an
mssql-db to mysql.
You will need to download the mysql-odbc-driver from http://www.mysql.com/downloads/api-myodbc-3.51.html

install it, create a odbc-source for the mysql-database,
and then you can select in the mssql-import-exprot-tool the mysql-database as
export-destination...
By: Bernard Date: 21/11/2004 17:09:01 English  Type : Comment
ok, but I leave this Q open to see if anybody has an other opinion ;-)
By: FiatLink Date: 19/12/2004 12:14:20 French  Type : Comment
Je pense que tu as eu toute la réponse possible 8-)

Do register to be able to answer

 Add This Article To:
 del.icio.usDel.icio.us  diggDigg  googleGoogle  spurlSpurl
 blinkBlink  wongWong  simpySimpy  yahooY! MyWeb 
EContact
browser fav
page generated in 64.735170 milliseconds

Why Google AdSense ads ?
compteur
 Ranking-Hits PageRank for this page