sql server connect: I have several different databases, including a single
Thorough-Bred database, an old My SQL and a new My SQL
database.

My question is this, can I merge all these into one single
database or is there a way to front all five data bases
with some type of gateway that somehow downloads every new
entry automatically to each of the old data bases.

Which would be better and how can it be accomplished.

Thanks in advance,

What matters most here is what the table structure and existing data in the
databases. If you have tables with the same name but different data, you
are going to have a lot of trouble merging all the data into one database.
Trying to figure out what version of data to keep will be difficult.

You can try experimenting with ODBC data sources (in Control Panel |
Administrative Tools) and create ODBC entries for all the data sources, then
an application or Enterprise (Security | Linked Servers | Add your odbc
sources).

--
*******************************************************************
Andy S.
andy_mcdba@yahoo.com

Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.

*******************************************************************
[quoted text, click to view]