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
 MSDE (2000)
 MSDE datatransfer

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-30 : 08:46:48
Anu writes "Data transfer of MSDE database from one location to a central location (through internet using a webspace)
(for example, from branches to headoffice)

Instead of transferring the full database , how can i transfer just the newly added or modified records of one

location to the central database?"

JustinBigelow
SQL Gigolo

1157 Posts

Posted - 2002-09-30 : 12:30:37
Thats a broad question so best I can offer is a broad answer. Look into replication. Here is a link to setting up and using replication from within MSDE [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q324992[/url]

hth,
Justin

Have you hugged your SQL Server today?
Go to Top of Page
   

- Advertisement -