Copy MySQL DB into SQLServer

[FGuijarro]

Hi,

I´m trying to copy a MySQL table into SQLServer.

Its MySQL structure is;

CREATE TABLE IF NOT EXISTS `Table_estadisticas` (

 `segundos` int(10) NOT NULL,

 `fecha` date NOT NULL,

 `prefijo` varchar(30) DEFAULT NULL,

 `origen` varchar(6) DEFAULT '0',

 `dest` varchar(6) DEFAULT '0',

 `sip_gateway_name_in` varchar(10) DEFAULT NULL,

 `sip_gateway_name_out` varchar(10) DEFAULT NULL,

 `tipo` int(10) NOT NULL,

 `direccion` int(10) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

How can I create that SQL Table?

Thank you!!

[root]

Do you want to achieve this automatically through Talend Job from the MySQL Schema? If yes, I am not sure if its possible.

However, this can be done via tCreateTable component if you know the schema before hand.