Databases :: MySql :: How to convert MS SQL 2000 Table structure to MySQL Table Structure |
|||
By: Bernard  |
Date: 15/11/2004 08:56:40   |
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 | |
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 | |
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 | |
Type : Comment |
| Je pense que tu as eu toute la réponse possible 8-) | |||
|
Do register to be able to answer |
|||
©2012 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 901 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
