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

[Jim Kinney]

give 'em an hourly data dump and a script to do the import and don't let
them touch the real systems. Show them the gui tools for MySQL and then
laugh. Any DBA worth their paycheck can be function in MySQL in a week using
a book like SQL in a Nutshell combined with the main docs for MySQL (which
are very good!).

If they screw up, convert the mess to Postgres with SELinux extensions and
give 'em an ODBC connection from MSAccess.

On Mon, Aug 23, 2010 at 10:53 PM, Mike Harrison <cluon at geeklabs.com> wrote:

> > They have DBAs that only know MS SQL.  If he can replicate between the
> > two then the DBAs can backup the slave (MS SQL) and use their Crystal
> > Reports against the data.  The will _NOT_ be able to do update, insert,
> > delete, or alter on any rows in the MS SQL database.
>
> And that's perfectly fine...and the way it should be.  :)
>
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo
>



-- 
-- 
James P. Kinney III
I would rather stumble along in freedom than walk effortlessly in chains.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.ale.org/pipermail/ale/attachments/20100823/bad23a6d/attachment.html