Database

View All Threads First Prev Next

mysql to ms sql server Ramkumar_S19-Apr-12 21:27 Ramkumar_S 19-Apr-12 21:27  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 Re: mysql to ms sql server Eddy Vluggen20-Apr-12 0:48 Eddy Vluggen 20-Apr-12 0:48  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 Re: mysql to ms sql server jschell20-Apr-12 10:27 jschell 20-Apr-12 10:27  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?

Last Visit: 31-Dec-99 18:00     Last Update: 15-Apr-24 23:44 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.