Integrate SQL Server Hedisql

[expired user #8517]'s profile image [expired user #8517] posted 9 years ago in General Permalink
Hi There,

I have two different databases in two different locations. Once use SQL server and other use Heidisql.

Now, is there a way where I can combine these two server and insert the data from one another. As I need data from both the places.

Thanks,
Ram
ansgar's profile image ansgar posted 9 years ago Permalink
If one is using MySQL and the other MSSQL, and you have tables with the same column names and similar data types, then you should be able to use HeidiSQL's SQL export dialog. Then, select Data: INSERT, and uncheck table and database structure. Source and target can be one of MySQL, MSSQL and PostgreSQL.

Please login to leave a reply, or register at first.