Migrating MySQL table to SQL Server

FGuijarro — Sat, 16 Nov 2024 00:58:24 GMT

Hi,

I am trying to copy a table from MySQL to SQLServer

Design is as follows:

tDBInput (MySQL) -- tMap -- tDBOutput (SQLServer, JTDS)

The structure of the input table is:

"CREATE TABLE IF NOT EXISTS `operador_modelo_negocio` (

`id` bigint(20) NOT NULL AUTO_INCREMENT,

fecha_inserccion timestamp

NOT NULL,

`cliente` bigint(20) DEFAULT '0',

`modelo_negocio` int(2) DEFAULT '3',

`dto_operador` double DEFAULT '0',

PRIMARY KEY (`id`),

KEY `cliente` (`cliente`),

KEY `modelo_negocio` (`modelo_negocio`)

);"

I´m getting the error message:

Picked up _JAVA_OPTIONS: -Xms1024m -Xmx8196m

[statistics] connecting to socket on port 4068

[statistics] connected

Exception in component tDBOutput_1 (MySQL_SQLServer_DBServerMovil)

java.sql.SQLException: Only dates in the AD era are accepted.

at net.sourceforge.jtds.jdbc.DateTime.<init>(DateTime.java:104)

at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setParameter(JtdsPreparedStatement.java:665)

at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.setTimestamp(JtdsPreparedStatement.java:1100)

at in2020_proyecto.mysql_sqlserver_dbservermovil_0_1.MySQL_SQLServer_DBServerMovil.tDBInput_1Process(MySQL_SQLServer_DBServerMovil.java:1195)

at in2020_proyecto.mysql_sqlserver_dbservermovil_0_1.MySQL_SQLServer_DBServerMovil.runJobInTOS(MySQL_SQLServer_DBServerMovil.java:1728)

at in2020_proyecto.mysql_sqlserver_dbservermovil_0_1.MySQL_SQLServer_DBServerMovil.main(MySQL_SQLServer_DBServerMovil.java:1577)

[statistics] disconnected

Job MySQL_SQLServer_DBServerMovil ended at 10:10 10/12/2020. [exit code = 1]

Any help with this error, please???

Re: Migrating MySQL table to SQL Server

root — Thu, 10 Dec 2020 16:36:00 GMT

I think you have an incorrectly formatted date in the Input data. Its not the best approach, but, I will change the schema of the IP component to varchar and then, in tMap, change it to appropriate format for MSSQL. HTH.

topic Migrating MySQL table to SQL Server in Talend Studio

Migrating MySQL table to SQL Server

Re: Migrating MySQL table to SQL Server