← Back to team overview

maria-discuss team mailing list archive

Thread
Date

Re: New Question: SQL Server replication to Maria DB

To: AskMonty KB <noreply@xxxxxxxxxxxx>
From: Richard Bensley <richardbensley@xxxxxxxxx>
Date: Wed, 13 Jan 2016 11:10:39 +0000
Cc: "maria-discuss@xxxxxxxxxxxxxxxxxxx" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <20160113022003.19852.66064@kb02.mariadb.com>

It would be much faster to use bcp to dump the data, and load it into
mariadb using the 'LOAD DATA INFILE' command.

You can use freebcp from the mariadb server to get data from mssql.

Rich

References

New Question: SQL Server replication to Maria DB
From: AskMonty KB, 2016-01-13