nixCraft Linux Forum

nixCraft

Linux / UNIX Tech Support Forum

Import SQL Database to MySQL!

This is a discussion on Import SQL Database to MySQL! within the Databases servers forums, part of the Mastering Servers category; Dear All, I want to import all my SQL Databases to the MySQL Database. Please give me solutions in detail. ...

Register free or login to your existing account and remove all advertisements.


Go Back   nixCraft Linux Forum > Mastering Servers > Databases servers

Linux answers from nixCraft.


Databases servers Discussions of databases of all types - especially MySQL.

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 04-16-2009, 10:17 AM
Junior Member
User
 
Join Date: Apr 2009
OS: Debian
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
nabila is on a distinguished road
Default Import SQL Database to MySQL!

Dear All,

I want to import all my SQL Databases to the MySQL Database.
Please give me solutions in detail.

Thank you so much
Reply With Quote
  #2 (permalink)  
Old 04-17-2009, 09:43 AM
nixcraft's Avatar
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
OS: RHEL
Scripting language: Bash and Python
Posts: 2,680
Thanks: 11
Thanked 241 Times in 181 Posts
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default

SQL Database? Is it MS-SQL or any other database?
__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help
Reply With Quote
  #3 (permalink)  
Old 04-17-2009, 09:48 AM
Junior Member
User
 
Join Date: Apr 2009
OS: Debian
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
nabila is on a distinguished road
Default

Yes, its' MSSQL
Reply With Quote
  #4 (permalink)  
Old 04-17-2009, 10:09 AM
nixcraft's Avatar
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
OS: RHEL
Scripting language: Bash and Python
Posts: 2,680
Thanks: 11
Thanked 241 Times in 181 Posts
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default

MySQL :: Migrating from Microsoft SQL Server and Access to MySQL

Edit: I'm not able to find out any free product but there are few commercial / proprietor software to do the same. See
http://www.convert-in.com/mss2sql.htm
__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help

Last edited by nixcraft; 04-17-2009 at 10:16 AM.
Reply With Quote
  #5 (permalink)  
Old 04-17-2009, 12:32 PM
Junior Member
User
 
Join Date: Apr 2009
OS: Debian
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
nabila is on a distinguished road
Default

Thnk you so much.. this link will be helpful to me.. And I better hope to find what I am searching for.. thank you again
Reply With Quote
  #6 (permalink)  
Old 05-21-2009, 03:35 PM
VVK VVK is offline
Junior Member
User
 
Join Date: May 2009
OS: Debian
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
VVK is on a distinguished road
Default How to Migrate SQL Server DB into MySQL

How to Migrate SQL Server DB into MySQL
Reply With Quote
  #7 (permalink)  
Old 08-27-2009, 12:39 PM
Junior Member
User
 
Join Date: Aug 2009
OS: Debian
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
wonn1377 is on a distinguished road
Default How to Migrate SQL Server DB into MySQL

I found a script online that says it converts databases from mssql to mysql. Check it out and let me know what you think:

http://www.convert-db.com/mssql-to-mysql.ht
Reply With Quote
Reply

Tags
convert mssql database to mysql , migrate ms sql to mysql


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
MySQL Rename Database SQL Command myfoot Databases servers 1 08-30-2008 05:54 PM
how to do MYSQL online backup of huge database manish_2479 Databases servers 4 07-12-2008 12:36 PM
need to convert text files into mysql database zafar466 Databases servers 2 07-12-2008 12:31 PM
ssh backup particular mysql table / database brothers Databases servers 11 10-25-2007 05:06 PM
Outlook Express mails import to Evolution ricc Linux software 2 03-09-2006 04:14 PM


All times are GMT +5.5. The time now is 08:45 PM.


Powered by vBulletin® Version 3.8.4 - Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2
©2005-2009 nixCraft. All rights reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38