Copy MySQL DB into SQLServer

FGuijarro — Sat, 16 Nov 2024 01:04:02 GMT

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!!

Re: Copy MySQL DB into SQLServer

root — Mon, 14 Dec 2020 15:59:15 GMT

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.