[ale] MS-SQL as slave/backup to MySQL

[James Sumners]

My boss likes MS-SQL Server. So I have to learn to use it. The little
I have done with it tells me that this question is probably
impossible. For example, both MS-SQL Server and MySQL have "timestamp"
types. In MySQL it does exactly what you would expect -- store the
current time and date[1]. What did MS do? Make it totally useless.
>From [2]:

"The Transact-SQL timestamp data type is not the same as the timestamp
data type defined in the SQL-92 standard. The SQL-92 timestamp data
type is equivalent to the Transact-SQL datetime data type."

So, my recommendation to you is to Just Say No.

[1] -- http://dev.mysql.com/doc/refman/5.0/en/timestamp.html
[2] -- http://msdn.microsoft.com/en-us/library/aa260631(SQL.80).aspx

On Mon, Aug 23, 2010 at 6:43 PM, Mike Harrison <cluon at geeklabs.com> wrote:
>
> Ok, it's probably a stupid idea, but I am being asked if anyone
> has ever slaved a MS-SQL system to a MySQL system
> so that the Microsofties can backup the data and do adhoc reports
> with the tools they know.
>
> Couldn't find anything googling.. but I may not know the proper things to
> be searching for.
>
> Shoot me.. I feel some pain coming on...


-- 
James Sumners
http://james.roomfullofmirrors.com/

"All governments suffer a recurring problem: Power attracts
pathological personalities. It is not that power corrupts but that it
is magnetic to the corruptible. Such people have a tendency to become
drunk on violence, a condition to which they are quickly addicted."

Missionaria Protectiva, Text QIV (decto)
CH:D 59