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

New Improved Search!

 


05/10/2011 1h30 : Steve Jobs is dead, the father of Apple ][ is gone, we are all orphaned.

Databases :: MySql :: convert mssql to mysql
By: carcinogen U.S.A.  Date: 25/06/2003 00:00:00  English  Points: 50 Status: Answered
Quality : Excellent
Hello Expertz,

We have a database in ms sql server 2000. I want to convert ms sql server 2000 database into mysql database.I dont have much knowledge about mysql but someone wants me to build a website using mysql.Currently our database is in mssql and i want to convert it into mysql.I have installed mysql but now my problem is i dont know how to go about it.Well the database is very large and i want to know how easily it can be converted to mysql and whats the easiest way to do that.
By: VGR Date: 25/06/2003 04:28:00 English  Type : Answer
you've to find a way to make SQL-S2000 dump the structure and data of the whole database in file(s), like "mysqldump" does (see documentation)

then importing is almost straightforward, if you used standard SQL and no "proprietary" stuff like IDENTITY, stored procs, etc
By: carcinogen Date: 25/06/2003 17:56:00 English  Type : Comment
I still did not understand wat the expert is trying to tell me.The database is in mssql(large) and i need to convert it into mysql and build a website with that.Its a report with various fields.
plz help me.
By: VGR Date: 25/06/2003 17:56:00 English  Type : Comment
As for your problem, What I'm trying to say is :
-you are supposed to know SQL-S 2K better than I do, and you've the product (not me, I HATE inefficient T-SQL) so you should find - in colleagues, in the documentation, in your scripts or in your memory :D - a way to export the data from this database. This is called "dumping the structure and the data"

That should produce a .sql or .txt file looking like this :
--
-- Table structure for table 'access_tbl'
--

CREATE TABLE access_tbl (
access_id tinyint(4) NOT NULL default '0',
access_name varchar(100) default NULL,
PRIMARY KEY (access_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'access_tbl'
--



--
-- Table structure for table 'account_tbl'
--

CREATE TABLE account_tbl (
account_id int(11) NOT NULL auto_increment,
account_name varchar(50) default NULL,
company varchar(50) default NULL,
first_name varchar(40) default NULL,
[...snip...]
--
-- Dumping data for table 'essai'
--


INSERT INTO essai VALUES (1,'AC028',NULL,NULL,NULL,NULL,NULL,NULL,'Close up of Buddha statue, Byodo In temple, Oahu','Asian Culture,
Island of Oahu, Byodo In temple',NULL,NULL,'',20030421104614,'0000-00-00 00:00:00',1,NULL,NULL,NULL,0,'John S. Callahan',NULL,NULL,
'|1|2|3|','|1|2|3|','|1|2|3|');
INSERT INTO essai VALUES (2,'AC029',NULL,NULL,NULL,NULL,NULL,NULL,'Two men Sumo wrestling','Island of Oahu, , Martial arts, Asian C
ulture, Men, Adults, Sumo wrestling',NULL,NULL,'',20030421105157,'0000-00-00 00:00:00',1,NULL,NULL,NULL,0,'Franco Salmoiraghi','MR',
NULL,'|2|4|5|1|6|7|8|','|2|4|5|1|6|7|8|','|2|4|5|1|6|7|8|');
INSERT INTO essai VALUES (3,'AC030',NULL,NULL,NULL,NULL,NULL,NULL,'Two men practicing Aikido, Martial arts','Island of Oahu, , Mart
ial arts, Asian Culture, Health, Men, Adults',NULL,NULL,'',20030421105157,'0000-00-00 00:00:00',1,NULL,NULL,NULL,0,'Franco Salmoirag
hi','MR',NULL,'|2|4|5|1|9|6|7|','|2|4|5|1|9|6|7|','|2|4|5|1|9|6|7|');
INSERT INTO essai VALUES (4,'AC031',NULL,NULL,NULL,NULL,NULL,NULL,'Man doing Tai chi in rain','Island of Oahu, Asian Culture, Heal
th, Men, Adults',NULL,NULL,'',20030417172332,'0000-00-00 00:00:00',1,NULL,NULL,NULL,0,'Franco Salmoiraghi','MR',NULL,NULL,NULL,NULL)
;
INSERT INTO essai VALUES (5,'AC032',NULL,NULL,NULL,NULL,NULL,NULL,'Japanese bride & Kimono dresser','Island of Oahu, , Asian Cultur
[...etc etc etc ...]


With this file, importing the whole database in MySql is a piece of cake.

Is this explanation detailed enough ?
By: carcinogen Date: 26/06/2003 00:30:00 English  Type : Comment
Thanks expert for the answer but i think i shld explain in detail if i need the real help.I need to build a website for a callcenter.For example fields like name of the agent,No of calls taken,Login time,not interested,not available,Answering machines,.........There are various fields like this.This full database is in mssql.I shld be buiding a website where these reports shld be updated daily and it shld be in the mysql.They shld be able to browse the site from anywhere and get to know the daily reports.They want it only on mysql...Well im not in any of the IT dept of the concern and im doing this as an project out of interest and to learn things.Wats the best that i can do about this?
Expecting the best from the expertz.
By: VGR Date: 26/06/2003 15:25:00 English  Type : Comment
I think you're not very serious about this.

I explained everything, and you don't understand
You want to perform a ***simple*** data migration between two almost-compatible systems, and you don't understand the very basic concepts of what I wrote : dumping-reproducing-importing data structure (database layout), then exporting-duplicating-importing the data themselves, and that's it.
To move the files, you also need some OS command like cp, copy, tar, a FTP or sshd... simple things

in a word as in one hundred, good luck
By: VGR Date: 26/06/2003 15:26:00 English  Type : Comment
You're not satisfied with the answers. I can't invent "fancy" answers to please you. What I wrote is only the complete truth. Baille-baille.
By: carcinogen Date: 28/06/2003 23:43:00 English  Type : Comment
Ur answer is very much to the mark.im satisfied with ur answer and im sure to come up with more doubts as i head to the project.Expecting ur help.....

Do register to be able to answer

©2010 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! Post to Twitter Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to Facebook Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

EContact
browser fav
page generated in 348.392010 milliseconds

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