SQL DB to MySQL

From: MTsang987 (MTsang987_at_discussions.microsoft.com)
Date: 12/02/04 

Date: Wed, 1 Dec 2004 17:25:03 -0800

We have SQL Server 2000 databases residing on one server, for reference I am
calling them DB1 and DB2. DB1 contains the main data,

DB2 contains data about the most recent changes to DB1, The key, table ID,
timestamp, and what action (insert, update, delete) occurred to DB1 is stored
in DB2.

We have a MySQL database connected to a live web server.

Our plan is to schedule a DTS package to update the MySQL database. The DTS
package uses a Data Driven Driven query task between the two SQL Server 2000
databases to populate the source that are sent to the bound MySQL database
using insert and update parameter queries.

My question is that is there a better way to do this?

Also, we are planning to schedule this package to run every 15 minutes, and
have a send email task in case of failure. Is there a way to stop the
scheduler automatically in case of a failure so that when there are multiple
failures and the recipient is busy they do not send out multiple emails?

Relevant Pages

  • Re: screwed non-us7ascii characters while selecting from a database link
    ... db1: ... db2 on SUSE SLES9. ... CREATE DATABASE LINK db1_link CONNECT TO user IDENTIFIED BY password ... from db1 and imp them into db2 the characters are converted correcly. ...
    (comp.databases.oracle.server)
  • Re: Equivalent of Oracles export/import in sql server
    ... I would not say a blanket statement like "Oracle ... DBAs should learn SQL Server" or "SQL Server DBAs should learn DB2". ... I would highly recommend learning Relational Database Theory. ...
    (comp.databases.oracle.server)
  • Re: Looking for a database
    ... >I am looking for a higher end database to replace our Access databases. ... than SQL Server, Oracle and DB2. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: ADO.NET and SQL, Oracle
    ... > I'm currently working as a DB2 and SQL Server 2000 administrator. ... > past I was a BI architect working with both Oracle and SQL Server ... > you have tons of features that you can't find in any other database. ...
    (microsoft.public.dotnet.framework.adonet)
  • Linking Tables in CR8.5 - DB2 to SQL Server
    ... Hi, I'm trying to link two tables together in a report, one from a DB2 ... database and one from SQL Server. ... table - the DB2 field is a character field length 5 and the SQL Server ... I've linked the tables via Crystal's Visual Linking Expert, ...
    (microsoft.public.vb.crystal)
Loading