Solved

Import simply accounting data into SQL Server Management Studio

Posted on 2014-03-07
5
636 Views
Last Modified: 2016-02-10
My Customer is using simply accounting and he wants to purchase my software that has its database on SQL Server.
Simply accounting data have the data in a file name ibdata1 and the log file are ib_logfile0 and ib_logfile1.
An MySQL folder is also in the directory with .FRM, .MYD and MYI files

I need to import this data into a database on SQL Server database named "Cartouches-Escomptes"

How can I achieve that?

Thank you
0
Comment
Question by:supportAutoCaisse
  • 3
5 Comments
 
LVL 26

Accepted Solution

by:
Zberteoc earned 500 total points
ID: 39912775
You basically need a import from MySQL server to SQL server.  There are tools for this, some tools you have to pay for but there are also free ones. You could use the SQL server's SSIS or import wizard but you would have to install the MySQL ODBC:

http://www.codeproject.com/Articles/29106/Migrate-MySQL-to-Microsoft-SQL-Server
0
 

Author Comment

by:supportAutoCaisse
ID: 39915516
Well, this was not very useful, first the data are in a file named ibdata and do not have any db file into the MySQL folder. I was hoping to find a real solution to import Simply Accounting Data into SQL Server, I begin to Wonder if it is Worth to pay for a membership if we receive only 1 solution that does not work. Do someone know how to import data from ibdata to SQL Server...??
0
 
LVL 35

Expert Comment

by:David Todd
ID: 39916728
Hi,

Having been employed by a firm that migrated quite a few accounting systems to ones we supported, the better idea is to export balanced and the normally static (slowly changing dimensions to borrow a phrase from BI) into excel, and then import that via standard modules into the new system. Trying to bring back transactions always led to a messy cutover and system.

I have a few questions from your comment above:
What was in the article that you didn't agree with? What didn't happen?

Regards
  David
0
 

Author Comment

by:supportAutoCaisse
ID: 39948223
I guess the best way to look at data in simply accounting is to connect using the ODBC driver, then, export to SQL.

Anyway that works!

Thanks for your help
0
 

Author Closing Comment

by:supportAutoCaisse
ID: 39948224
Thanks
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now