Hi guys

Can anyone advise the best practise for developing DTS for my problem.

I have two MS SQL 2000 Sever DBs. One which we call WebCS is a duplication
of the other (CS) with a little change. The difference between two database
is a table. CS DB has tables called group (id, name, ostype), host (id,
hostname, location) and group_host (id, group_id, host_id).

In second DB (WebCS) we add a table called company (id, company_name) to
manage clients and modified the other two tables: group (id, name, ostype,
company_id) , host (id, hostname, location, company_id). company_id in both
tables are foreign keys for id in company table.

I need to update company_id in host table in WebCS based on comparing host
name and company_name and the same in group table.

We need to syncronise two DBs. Any help will be highly appreciated.

Thanks.

Same server ?

Simply use 3 part naming

dbname.ownername.tablename

If they are different servers?

What about using a linked server ?

If you do not want to use any of the above then you can use a Data Driven
Query although I would generaly look to other options first



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Hami" <Hami (AT) discussions (DOT) microsoft.com> wrote