935486 wrote:They require the DATA IN the table, not the table itself.
We have a table being populated in a mysql db in linux platform using java application. Another party would require this table but their platform is windows and db is sqlserver. Which solution is the best to pass on the data
1) Write a java application reading from mysql and inserting into sql server.That could work, but you'd need to be able to connect to both machines from one location.
2) Write a web service but the problem linux is not well supported for web services?What kind of nonsense is that? What kind of limitation can an OS put on web services?
Which is a better method in terms of security and performance?3) export data to a well-known format (CSV for example), encrypt it using for example PGP, give it to "the other people" and let it be their responsibility to import it again into their own database in whatever way they find secure.
935486 wrote:Oh yeah? I've written systems that fully automate it, no problem. Including taking deltas in stead of full dumps. The limitation is more what you are capable of, not what is or isn't possible. And yeah... that's up to you to define where the boundaries are.
The issue with the third method is that we have to manually pass the data.
What is best mechanism in terms of security and performance?I already gave my opinion, repeating the exact same question isn't going to net you a different answer. I'll only answer this extra: there is no best, stop looking for it. In stead, look for a way that works within your limitations, boundaries and budget. Should be a lot simpler to answer yourself now that you can stop looking for that which does not exist.
gimbal2 wrote:There's apparently a solution which involves no dumps, no deltas, and in fact no copying of any data at all. It's possible to use MySQL as a "linked server" in SQL Server. So you can access the MySQL table directly, just as if it were an SQL Server table.
Oh yeah? I've written systems that fully automate it, no problem. Including taking deltas in stead of full dumps.