Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asp__developer
Posting Yak Master
108 Posts |
 Posted - 2010-05-12 : 12:44:25
|
| I've been provided with mysql database backup files which have this format "mysqlbackup.data"i want to extract the data in any readable format in excel of MS SQL database to atleast i can get the data in these databackup filesPlease guide me |
|
|
asp__developer
Posting Yak Master
108 Posts |
Posted - 2010-05-12 : 18:41:21
|
| just to provide more information let me explain you how i get this backup file:we are using a software since few months and soon we are switching to a new software so we want to keep a backup of all the records in the current software, that is the reason i want to convert this backup file into readable formatNow coming back to backup file, the software company installed a different dos software that is connected with the database of the software we are using currently, and this dos software is used to take a backup of current databaseIn order to get the backup, what i do > i just have to go open the software and click on button "Back Your Database" - as soon as i click the button, it run a number of commands in dos prompt (black screen appears) and within few seconds a backup.data file is generated in the output folder.I don't have any experience with mysql so don't know what is the format of this backup files that's why iam telling you about the extension - the extension of this file is ".data"i have no idea what exactly is there in the backup file as it is being generated with a software thru dos commands(i notices when thes dos commands are running in dos prompt there are few linux commands too)That's all i know about the backup file and that's the best explaination i can provide you about it. the software is online based i mean it is linked with the software companyso we don't have anything at our endthe software company manages the database and everythingthe dos software that they provided is also linked with the database at their end, so when we take a backup it gives a back file to us in our machineHope it helps |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-13 : 02:54:14
|
| My best guess would be that you have to install MySQL, create a database in MySQL and restore the backup file into it (using MySQL)You can then set up a Linked Server in SQL Server, configured to connect to MySQL (and that can be on the same machine, or a different machine, your choice).Then you will be able to see the MySQL database directly from SQL Server - so you can copy data (in either direction), or just Query MySQL tables from SQL Server.Description of how to set up a Linked Server to MySQL here:http://www.packtpub.com/article/mysql-linked-server-on-sql-server-2008 |
|
|
|
asp__developer
Posting Yak Master
108 Posts |
Posted - 2010-05-13 : 09:25:04
|
| Thank you for your reply, could you please explain me how to install MySQL on my machine, as i have no experience in using mySQL. It will be great if you could explain me in detail what exactly i have to do and how.(I downloaded "MySQL Community Server" from here [url]http://dev.mysql.com/downloads/mysql/[/url], (Windows (x86, 32-bit), MSI Installer), it has installed something related to mysql , whenever i open it, it gets open in dos/command prompt and i have no idea what i have to do) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-13 : 09:40:18
|
| I have no idea about MySQL as this is a Microsoft SQL Server site.I believe there is a support forum on www.MySQL.com, otherwise you will need to Google for one. |
|
|
|
asp__developer
Posting Yak Master
108 Posts |
Posted - 2010-05-13 : 10:32:45
|
| i understand Kristen, i have posted the same problem on mySQL forum too but no replyI posted this problem here as i thought someone might know about it.Well thank you very much for all your replies Kristen, i appreciate it. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-13 : 12:16:52
|
| You only need the MySQL forum people to help you with install, and restore, of your "local" MySQL database.Thereafter I expect folk here can help with getting the data into SQL Server.I'm not aware of any regulars here who are skilled at MySQL (we're a snobby lot!!) but someone may put their head above the parapet now!! |
|
|
|
|
|
|
|
|
how to transfer data from mysql to MS SQL database