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 |
|
Jay007
Starting Member
1 Post |
 Posted - 2014-09-10 : 16:34:28
|
| I have a few fields from 2 tables on two different databases I want to sync on a daily basis. One database is mssql and the other is mysql. I have successfully created a linked mysql server. Does anyone know the best way to achieve this. I am using sql 2012 express. I don't mind using 3rd party |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-09-11 : 09:30:55
|
| in SSIS, use the Slowly Changing Dimensions transformation in the dataflow |
 |
|
|
|
|
|
Sync fields