Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 export

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-02-19 : 07:49:39
jshanoo writes "I want to design a data export process.
The purpose is mentioned below
My major database is web and it is around 3-4gb,
On daily basis , I will be having update of 1000> records.
Local database with have field in all tables named <recordtype>
It contains values
1 - New
2 - Edit
3 - Dele
now looking at the above mentioned values in local table,
DTS has to add new, modify or delete the records in the remote database.
I have used only DTS wizard for this till date.
Can I do this thru wizard or any other suggestions.
I am using Windows 2000 professional SP3.
and SQL server 2000 SP2"
   

- Advertisement -