mysql to ms sql server
-
Hi All, I have same table structure in Mysql and sqlserver. If there is change in Mysql table, then sqlserver table should get updated. Please suggest proper way to do. We dont have SSIS we only use ssms2005 express. Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com
-
Hi All, I have same table structure in Mysql and sqlserver. If there is change in Mysql table, then sqlserver table should get updated. Please suggest proper way to do. We dont have SSIS we only use ssms2005 express. Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com
Ramkumar_S wrote:
Please suggest proper way to do.
Sql Express doesn't offer this functionality out of the box. You'd have several options;
- Add the MySql server as a linked server and sync using triggers
- Write an app to do the synchronization, using the Sync Framework
- Upgrade Sql Server
Bastard Programmer from Hell :suss:
-
Hi All, I have same table structure in Mysql and sqlserver. If there is change in Mysql table, then sqlserver table should get updated. Please suggest proper way to do. We dont have SSIS we only use ssms2005 express. Ramkumar ("When you build bridges you can keep crossing them. ") http://ramkumarishere.blogspot.com
I suspect the solution would require that you first analyze what happens if there is an error. For example you update the MySQL table and at that moment the SQL Server database is down so of course the corresponding table cannot be updated then - so what do you expect to happen then? Additionally how soon does the data need to be in the SQL Server database?