sql server dts: You can do it a number of ways and depending on how much data involved and
the speed of your link may influence your decision.

Large Data:

On a slow link this may be more trouble than it is worth to use a tool such
as DTS. I would be looking to BACKUP the remote DB and RESTORE it locally.

Small Data

You can use the COPY Objects task. This will transfer what you want.


Do you really need to copy all data every time. If not I would be looking
to see how I could identify those rows that I do need to transfer and only
move those rows.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


[quoted text, click to view]

Dear Professional

I wanna copy the remoted database into local database through DTS. Can any
body tell me the steps for copying the databasese from remote server to
local server.

Thanks in advance.

Noor