Solved

Import simply accounting data into SQL Server Management Studio

Posted on 2014-03-07
5
640 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

863 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

21 Experts available now in Live!

Get 1:1 Help Now