migrate sql(Windows) databases to mysql(linux)

Taking care of your Linux box.

migrate sql(Windows) databases to mysql(linux)

Postby ghulam yaseen » Tue May 12, 2009 7:00 pm

Hello All,

I am looking for a technique or tool so that i can migrate SQL databases into mysql(linux).

Best Regards,
Ghulam Yaseen
ghulam yaseen
Naik
 
Posts: 68
Joined: Thu Aug 07, 2008 6:09 pm
Location: karachi

Postby lambda » Tue May 12, 2009 7:21 pm

all you need to do is dump the tables/databases and restore them. use mysqldump, probably with the --opt flag.

mysql's docs are very detailed.
Watch out for the Manners Taliban!
Isn't it amazing how so many people can type "linuxpakistan.net" into their browsers but not "google.com"?
lambda
Major General
 
Posts: 3452
Joined: Tue May 27, 2003 7:04 pm
Website: http://www.hungry.com/~fn/
Location: Lahore

Re: migrate sql(Windows) databases to mysql(linux)

Postby LinuxFreaK » Thu May 14, 2009 7:40 am

Dear ghulam yaseen,
Salam,

ghulam yaseen wrote:I am looking for a technique or tool so that i can migrate SQL databases into mysql(linux).


You can use MySQL Migration Toolkit.

FYI, http://dev.mysql.com/doc/migration-tool ... mssql.html

Best Regards.
Farrukh Ahmed
LinuxFreaK
Site Admin
 
Posts: 5132
Joined: Fri May 02, 2003 10:24 am
ICQ: 82075802
Website: http://www.linuxpakistan.net/wiki/index.php?pagename=LinuxFreak
WLM: f4fahmed@hotmail.com
Yahoo Messenger: f4fahmed@yahoo.com
AOL: linuxpakistan@aol.com
Location: Karachi

Postby lambda » Thu May 14, 2009 10:27 am

huh, i guess people really do mean microsoft's sql server when they say "sql". probably like how "browser" means "internet explorer" to most people.
Watch out for the Manners Taliban!
Isn't it amazing how so many people can type "linuxpakistan.net" into their browsers but not "google.com"?
lambda
Major General
 
Posts: 3452
Joined: Tue May 27, 2003 7:04 pm
Website: http://www.hungry.com/~fn/
Location: Lahore

Postby LinuxFreaK » Sun May 17, 2009 7:43 pm

Dear lambda,
Salam,

lambda wrote:huh, i guess people really do mean microsoft's sql server when they say "sql". probably like how "browser" means "internet explorer" to most people.


hehe, what should i say. People may think any thing as they have their own mind :)

Best Regards.
Farrukh Ahmed
LinuxFreaK
Site Admin
 
Posts: 5132
Joined: Fri May 02, 2003 10:24 am
ICQ: 82075802
Website: http://www.linuxpakistan.net/wiki/index.php?pagename=LinuxFreak
WLM: f4fahmed@hotmail.com
Yahoo Messenger: f4fahmed@yahoo.com
AOL: linuxpakistan@aol.com
Location: Karachi


Return to “%s” Administration

Who is online

Users browsing this forum: No registered users and 1 guest

cron