LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-11-2010, 06:54 AM   #1
divyashree
Senior Member
 
Registered: Apr 2007
Location: bbsr,orissa,India
Distribution: RHEL5 ,RHEL4,CENT OS5,FEDORA,UBUNTU
Posts: 1,362

Rep: Reputation: 135Reputation: 135
mdf to sql


I have dat from MSSql server as .mdf format and I want to convert it into .Sql format ,so that I can import it into mysql.

How will I convert it ?
 
Old 10-11-2010, 09:03 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,916

Rep: Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689
Quote:
Originally Posted by divyashree View Post
I have dat from MSSql server as .mdf format and I want to convert it into .Sql format ,so that I can import it into mysql.
How will I convert it ?
Again, did you even try to look this up???
http://dev.mysql.com/tech-resources/...microsoft.html

You've got options, if you've got access to a MSSQL server. You can use the DTS Services (included with MSSQL), import the file into Access, and use the export function, or do a dump of the database to a common format like CSV, and import that into MySQL.
 
Old 10-12-2010, 03:12 AM   #3
divyashree
Senior Member
 
Registered: Apr 2007
Location: bbsr,orissa,India
Distribution: RHEL5 ,RHEL4,CENT OS5,FEDORA,UBUNTU
Posts: 1,362

Original Poster
Rep: Reputation: 135Reputation: 135
Quote:
Originally Posted by TB0ne View Post
Again, did you even try to look this up???
http://dev.mysql.com/tech-resources/...microsoft.html

You've got options, if you've got access to a MSSQL server. You can use the DTS Services (included with MSSQL), import the file into Access, and use the export function, or do a dump of the database to a common format like CSV, and import that into MySQL.
No,I dont have access to MSSQL Server. If I had access, then I can do that easily.
 
Old 10-12-2010, 03:15 AM   #4
prayag_pjs
Senior Member
 
Registered: Feb 2008
Location: Pune - India
Distribution: Fedora,RedHat,CentOS,Gentoo
Posts: 1,138
Blog Entries: 4

Rep: Reputation: 147Reputation: 147
Did you hack the system?
 
Old 10-12-2010, 04:08 AM   #5
divyashree
Senior Member
 
Registered: Apr 2007
Location: bbsr,orissa,India
Distribution: RHEL5 ,RHEL4,CENT OS5,FEDORA,UBUNTU
Posts: 1,362

Original Poster
Rep: Reputation: 135Reputation: 135
Quote:
Originally Posted by prayag_pjs View Post
Did you hack the system?
No yaar, the mdf file is given to me and there is no databse of SugarCRM on that SQL Server after backing it up. I thing after backing it up ,they have deleted it.

I dont want to mess up as a lot of intranet services are running in that windows server with a lot of databases. I just started migrating the services from windows server to Linux server.

One thing I can do ,I can import that mdf file in SQL server and then I can export to other format. or with any external tool I can use to convert that mdf to .sql or any help from here.
 
Old 10-12-2010, 08:42 AM   #6
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,916

Rep: Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689Reputation: 3689
Quote:
Originally Posted by divyashree View Post
No yaar, the mdf file is given to me and there is no databse of SugarCRM on that SQL Server after backing it up. I thing after backing it up ,they have deleted it.

I dont want to mess up as a lot of intranet services are running in that windows server with a lot of databases. I just started migrating the services from windows server to Linux server.

One thing I can do ,I can import that mdf file in SQL server and then I can export to other format. or with any external tool I can use to convert that mdf to .sql or any help from here.
Right...which is what I posted originally:
Quote:
Originally Posted by TB0ne
You've got options, if you've got access to a MSSQL server. You can use the DTS Services (included with MSSQL), import the file into Access, and use the export function, or do a dump of the database to a common format like CSV, and import that into MySQL.
So, import it into Access on a workstation, then export so you've got something you can re-import into MySQL.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mds/mdf kuba-g Linux - Software 0 04-14-2006 05:38 PM
MDF/MDS files winterhunter Linux - Software 1 02-03-2006 03:11 PM
mdf to iso9660 weepenguin Linux - Newbie 1 04-04-2005 02:10 PM
.mds and .mdf to iso xIEatxChildrenx Linux - Software 2 03-11-2005 02:01 PM
shadow passwords and mdf njnear Linux - Security 5 08-06-2003 04:41 PM


All times are GMT -5. The time now is 11:03 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration