Tuesday, October 11, 2016

Getting data out of SQL Server in a MariaDB friendly way.

I know what you are thinking "Oh my, it's that time again, Karlsson insist that data should get out of some other database and into MariaDB. What is he up to this time?" and that is exactly right, this time data is coming out of SQL Server, out of that expensive, closed source, Windows-only software and into the lightweight, fast and cost effective MariaDB.

I have already shown how this works when getting data out of Oracle in releasing MyOraDump, so inline with that the corresponding program to get data out of SQL Server is called MyMSSQLDump and it has features along same same lines as MyOraDump. To connect to SQL Server (or Sybase, but this I haven't tested) I use FreeTDS, which is a nice Open Source SQL Server / Sybase driver. The output formats supported are MySQL (i.e. A file with (INSERT INTO...), MSSQL (same as MySQL format but aligned for MSSQL), JSON, JSON Array (similar to JSON but all data in one array) and CSV. All formats are very flexible and the common SQL Server / Sybase datatypes are supported.

As usual, the code is written in C and use autotools for building. I have only tested building it on CentOS (6 and 7) so far, but there is nothing magic to it so it should work on other platforms too. Download it from sourceforge.

Happy SQL'ing
/Karlsson

14 comments:

Alina Florence said...

Hi, I am Alina. SQL Server Management Studio agrees one to generate a working SQL script to recreate a database something that MariaDB operators refer to as a dump. It could be essential to adjust some of these options to make the output well-matched with MariaDB. Now, I am an Academic Writer and your right place for buy persuasive essay at the best price and best grades.

Lola Nickson said...

Hi, I am Lola Nickson and I have been working as a full time academic consultant writer with Livewebtutors.com. I along with my large team have been providing paper writing service help and aiding students to seek assistance from essays, dissertation, projects, thesis and more. You can visit the online platform to seek high quality academic services. You blog is a magic wand for me, because I find a great inspiration reading your articles. Thanks a lot!

1292lillyS said...

Hello. Thanks for sharing. I download it from sourceforge and I managed to use it. But it took more time than I thought as a result now I have to find pre written essay for my classes. I think I can do it too.

joyalex said...

While compare quicken and quickbooks the quicken is the small accounting tool for the self owned firm and quickbooks is for big managing firm for good accounting like payroll, core accounting

Quickbooks error said...

The Quickbooks error 6210 is a 6000 series Quickbooks error that generally can be seen when a system other than the host server accesses the company files. This quick glance won’t help you much so, we have brought together all the significant aspects related to QuickBooks error -6210. Know how to resolve this error with the help of QuickBooks Tool Hub. Visit us

Digital Marketer said...

I know what you're thinking "Oh my, it's time again, Karlsson emphasizes that data should come out of another database and into MariaDB. I can say that this is a useful site for us. What are you up to now? ” and that is normal, this time data comes out of SQL Server, from that expensive, closed source, software-only software and into the lighter, faster and more cost-effective MariaDB. To connect to SQL Server (or Sybase, but this I haven't tried yet) I use FreeTDS, which is an excellent Open Source SQL Server / Sybase driver. Supported formats include MySQL, MSSQL, and CSV.

Unknown said...

I know your opinion "Goodness my, here we go, Karlsson demand that information ought to escape another data set and into MariaDB.Do My Homework For Me What is he up to this time?" and that is spot on, this opportunity information is emerging from SQL Server, out of that costly, shut source, Windows-just programming and into the lightweight, quick and financially savvy MariaDB.

katie laner said...

Indeed this is very useful for all and thanx for sharing this information with us as i am searching for this type of app for so long and now i get to know about this with your help and also i am a technician so if you want to get some knowledge about quickbook unexpected error 5 then must go through the above mentioned linkquickbooks unexpected error 5: A QBs Repairing Guide


Adam Lee said...

The rising geriatric population in developed and developing regions will positively influence the growth of the urinalysis market globally. Due to rapid growth in the senior population, the prevalence of age-associated diseases such as diabetes, liver, and kidney diseases are expected to increase significantly.

Also Read: Needle Coke Market | Aerospace Fasteners Market | Haemophilia Treatment Market

Cali Luna said...

It is genuinely a fantastic article to read. I am fascinated by the level of research you do. I provide Herrschners Coupon, people benefit from it, and many more coupons are available.

Accounting Data Solutions said...

quickbooks closes unexpected with or without an error because of several reasons. For instance, you may be creating an invoice and the QuickBooks will suddenly stop responding and close automatically Subsequent article is incorporated with some of the most effective techniques to resolve QUICKBOOKS 2014 CLOSES UNEXPECTEDLY WINDOWS 10, Still we recommend you to contact QuickBooks Support Team at +1-855-738-0359 while applying the below mention solutions”

Accounting Data Solutions said...

How to tackle with Fix QuickBooks Error Code 6175 , most of the 6000 series errors are related to the company file and appear when you try to access the company file in QuickBooks Awesome blog!! Thank for providing excellent information. if you have any issues with Fix QuickBooks Error 6175 you can go through the detailed steps mentioned in this article. +1(855)-738-0359 and get instant solutions within no time possible

Gwendolyn Taylor said...
This comment has been removed by the author.
Gwendolyn Taylor said...
This comment has been removed by the author.