ApatarForge
Apatar.com  |  Log In   
close x
First Name Last Name E-mail Telephone Message

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups    RegisterRegister 
  ProfileProfile     Log in to check your private messagesLog in to check your private messages    Log inLog in  

Migrating Data from MSSQL Server to MySql Server
Goto page 1, 2  Next
 
Post new topic   Reply to topic    Apatar Community Forums Forum Index -> DataMaps
View previous topic :: View next topic  
Author Message
BinCoder
Guest
PostPosted: Mon Jul 26, 2010 7:07 am    Post subject: Migrating Data from MSSQL Server to MySql Server Reply with quote
Hi guys,

I have tried to migrate some data from MSSQL server to the MySql Server, i am able to view results in the transform element but when i try to preview the results in the MySql element i dont see anything?What could be the reason.

Thanks
Back to top
Sergei



Joined: 26 Jul 2007
Posts: 969
PostPosted: Mon Jul 26, 2010 11:58 am    Post subject: Re: Migrating Data from MSSQL Server to MySql Server Reply with quote
BinCoder wrote:
Hi guys,

I have tried to migrate some data from MSSQL server to the MySql Server, i am able to view results in the transform element but when i try to preview the results in the MySql element i dont see anything?What could be the reason.

Thanks


Did you get any errors?

Regards,
Sergei
Back to top
View user's profile Send private message Send e-mail Visit poster's website
BinCoder
Guest
PostPosted: Tue Jul 27, 2010 8:30 am    Post subject: Reply with quote
No i did not get any .
Back to top
Sergei



Joined: 26 Jul 2007
Posts: 969
PostPosted: Tue Jul 27, 2010 12:25 pm    Post subject: Reply with quote
BinCoder wrote:
No i did not get any .


Could you please send your datamap to me?

Regards,
Sergei
Back to top
View user's profile Send private message Send e-mail Visit poster's website
BinCoder
Guest
PostPosted: Tue Jul 27, 2010 1:20 pm    Post subject: Reply with quote
how do i attach the file here in this thread?

BTW it is a very simple thing

MSSQL >> Transform >> MySql

But the MySql db is not populated with the data.
Back to top
Sergei



Joined: 26 Jul 2007
Posts: 969
PostPosted: Tue Jul 27, 2010 1:53 pm    Post subject: Reply with quote
BinCoder wrote:
how do i attach the file here in this thread?

BTW it is a very simple thing

MSSQL >> Transform >> MySql

But the MySql db is not populated with the data.


MySQL set to insert or update mode?

You can send your datamap directly to sergei.l at apatar dot com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
BinCoder
Guest
PostPosted: Tue Jul 27, 2010 2:20 pm    Post subject: Reply with quote
Thanks Sergei,

Its set to insert mode for mysql.

I will send you the datamap soon.
Back to top
BinCoder
Guest
PostPosted: Tue Jul 27, 2010 2:30 pm    Post subject: Reply with quote
I have sent and email already now.

Let me know what is the problem.

Thanks
Back to top
BinCoder
Guest
PostPosted: Sun Aug 01, 2010 10:57 am    Post subject: Reply with quote
Dear Sergie,

I tried the steps you outlined but still it did not work out. I added a custom table to check and that gets populated properly. What else do you think could be going on?
Back to top
BinCoder
Guest
PostPosted: Mon Aug 02, 2010 11:31 am    Post subject: Problem Exportibg Data from MSSQL and importing to MySql Reply with quote
Hi Guys,

I am still facing problems with importing data in to MySql Database from the MSSQL DB.I have currently setup the MySql DB to be MyISAM based and even checked the field values and ensured that they are the same but still for some reason my mysql db is still empty.
Back to top
BinCoder
Guest
PostPosted: Mon Aug 02, 2010 3:23 pm    Post subject: Reply with quote
The following is the error i get from the show error tab.


*********************************
Start date Mon Aug 02 18:49:14 GST 2010
Version Apatar_v1.12.11
JRE Version 1.6.0_17
JRE Vendor Sun Microsystems Inc.
log4j.configuration = `null`
Start Reading from MattInf
Start Reading from MattInf
Start Reading from MattInf
Start Reading from MattInf
java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.String
at com.apatar.core.DataBaseTools.setDataToPS(DataBaseTools.java:1601)
at com.apatar.core.AbstractJdbcDataBase.insertOneRow(AbstractJdbcDataBase.java:329)
at com.apatar.core.AbstractJdbcDataBase.TransformTDBtoRDB(AbstractJdbcDataBase.java:272)
at com.apatar.mysql.MySqlNode.TransformTDBtoRDB(MySqlNode.java:188)
at com.apatar.core.AbstractDataBaseNode.Transform(AbstractDataBaseNode.java:363)
at com.apatar.core.AbstractDataBaseNode.Transform(AbstractDataBaseNode.java:333)
at com.apatar.core.Runnable.execute(Runnable.java:207)
at com.apatar.core.Runnable.execute(Runnable.java:187)
at com.apatar.core.Runnable.execute(Runnable.java:181)
at com.apatar.core.Runnable.executeToNode(Runnable.java:174)
at com.apatar.core.Runnable.access$0(Runnable.java:171)
at com.apatar.core.Runnable$Run.run(Runnable.java:85)
Start Reading from matter
Back to top
Sergei



Joined: 26 Jul 2007
Posts: 969
PostPosted: Tue Aug 03, 2010 4:18 pm    Post subject: Reply with quote
Hello,

You currently have version
Quote:
Version Apatar_v1.12.11


Please download the latest version of Apatar 1.12.12. Also if you used the patch for 1.12.11, make sure that you replaced the correct files.

Regards,
Sergei
Back to top
View user's profile Send private message Send e-mail Visit poster's website
ctrl-alt-del
Guest
PostPosted: Wed Dec 15, 2010 9:14 am    Post subject: Reply with quote
hi,

i have a problem migrating from MSSQL to MySQL. my apatar version is 1.12.13

the problem is when i'm using innoDB at MySQL. the data cannot be migrated. but if i'm using myISAM.. all the data are migrated.

do we need to change the table from innoDB to MyISAM?
Back to top
Sergei



Joined: 26 Jul 2007
Posts: 969
PostPosted: Wed Dec 15, 2010 11:56 am    Post subject: Reply with quote
ctrl-alt-del wrote:
hi,

i have a problem migrating from MSSQL to MySQL. my apatar version is 1.12.13

the problem is when i'm using innoDB at MySQL. the data cannot be migrated. but if i'm using myISAM.. all the data are migrated.

do we need to change the table from innoDB to MyISAM?


Correct.
_________________
Regards,
Sergei
Back to top
View user's profile Send private message Send e-mail Visit poster's website
ctrl-alt-del
Guest
PostPosted: Thu Dec 16, 2010 4:02 am    Post subject: Reply with quote
thanks sergei

does this mean that apatar doesn't support InnoDB for MSSQL -> MySQL migration? because, i thought InnoDB is supported by apatar.

Quote:

Apatar Open Source Data Integration features and benefits:
- No coding! Visual job designer and mapping enable non-developers to design and perform transformations, shortening implementation time
- Distributed under an open source model, reducing integration and maintenance costs
- Connectivity to Salesforce.com, SugarCRM, MySQL, Oracle, MS SQL, Microsoft Excel, Microsoft Access, GoldMine, DB2, Sybase, PostgreSQL, dBase, EnterpriseDB, vTiger, InnoDB, Vertica Analytic Databse, Openbravo ERP, Compiere ERP, .CSV, XML, RSS, ATOM, HTTP queries, POP3, LDAP, FTP, WebDav, Autodesk Buzzsaw, any JDBC data sources, Amazon S3, Flickr, StrikeIron and CDYNE data quality Web services, and more
- Job scheduler and synchronization automate the data integration process
- Improves data quality with a variety of verification, filtration, and validation features
- Users have the ability to create, share, and re-use pre-built data transformations and publish data integration output as a custom RSS feed to ApatarForge, the online Apatar community
- Platform-independent, runs from Windows, Linux, and Mac OS.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Apatar Community Forums Forum Index -> DataMaps All times are GMT
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group