Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Import simply accounting data into SQL Server Management Studio

Posted on 2014-03-07
5
Medium Priority
?
705 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 27

Accepted Solution

by:
Zberteoc earned 1500 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

886 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