Hi ,

I have 10 Client's sql server databases residing on different systems. Now
I want to Pull data from all the 10 database into one Consolidated sql
server Database.
What is the technology that I should use??

Please Help me


Thanks in advance..

Regards
Srinivas Govada

There are a variety of things you can do.

You could use Replication
You can use DTS
You can use straight TSQL


There will be a lot of planning involved whichever you choose.

Are these 10 * the same database just different information?
Are these 10 * different schema and you want to make something akin to a
data warehouse.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Govada" <sgovada (AT) stcroixsystems (DOT) com> wrote

Hi ,
All these databases(10) have same schema. How ever data is different. I need
to consolidate all database for datawarehouse.

Regards
Srinivas Govada


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Then my original suggestion stands.

You can consolidate all data using any of these methods. My preference
would be to use DTS but that's me.

Is the data split i.e. site 1 can only see their data/make changes to their
data?

The implementation is too big for a NG post but you will need to initially

1. Load all data for all sites/de-duplicating/scrubbing into the
consolidated DB
2. Monitor changes are each site
3. Replicate (and I use that word meaning to duplicate not in reference to
SQL Server replication) those changes to the consolidated DB
4. Work out if you will therefore need to replicate those changes across
ALL sites.

Replication will handle a lot of this for you as it can handle the changes
and the conflicts but requires implemntation knowledge i.e. an extra
attribute will be added to your entities and you need to understand the
conflict resolution models as well.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Govada" <sgovada (AT) stcroixsystems (DOT) com> wrote

Thanks for the reply..

I will try using above solution and get back for futher clarification


Thanks once again

with regards
Srinivas Govada


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote