Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shaihan
Starting Member
20 Posts |
 Posted - 2009-03-25 : 00:48:23
|
| i have a sql server db where i need to forward data to a mysql server which is residing on a different server. another server, which i dont have any control over, will insert data into my mssql server. whenever there is new data i'll have to forward the data to that mysql db. is there any way to forward data from mssql to mysql?thank youS ]-[ /-\ | ]-[ /-\ N |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-25 : 14:06:14
|
| yup. you can configure a linked server b/w mysql and your mssql server and then schedule a job for transfering new/changed data to mysql server based on audit column value (like dateadded) or pk value |
 |
|
|
shaihan
Starting Member
20 Posts |
Posted - 2009-03-26 : 05:01:52
|
| thanks. but i can not use linked server as i don't have system level access to the mssql server. they won't allow me to install the odbc connector for mysql.S ]-[ /-\ | ]-[ /-\ N |
|
|
|
|
|
|
urgent - how to forward data to mysql server