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 |
|
SergioM
Posting Yak Master
170 Posts |
 Posted - 2010-08-27 : 21:50:18
|
| I know may be an obvious question, but please bear in mind how new I am to this. I have SQL Server 2005 on a File Server locally. I also have an eCommerce website hosted on a 1and1 Server which uses MySQL. I would like to synch the two databases on a daily basis. I have done quite a bit of reading and it seems to me that SSIS is the tool for the job. My two questions are: (1) Can it do it across the internet? IE not both local DBs.(2) Can it synchronize the DBs even though one is SQL Server 2005 and the other one is MySQL 5? |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2010-08-27 : 23:02:22
|
http://www.packtpub.com/article/mysql-data-transfer-using-sql-server-integration-services-ssis
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
 |
|
|
|
|
|
Synchronizing SQL 2005 & MySQL