RE: UPLOADING DATA TO REMOTE SERVER

> Hey Foxperts
> I need some suggestion on what would be the best way, i.e. most secure and fastest, to upload data to tables on a remote server. I have an ASP.NET site that uses two tables from our local database. But the site has its own database and due to the requirements of management my site must stand alone and is updated periodically so that employees in other countries can access my site and view the data, is there a way to make this upload automated so that it runs by it self, say everyday at 12:00 AM?
>
> I don't really have any ideas as to how I am gonna do the syncing so any help will be greatly appreciated.
>
> Thanks in advance.
>
> Nyron Williams
> If fire fighters fight fire and crime fighters fight crime, then what do freedom fighters fight???

If your back end data is SQLSERVER, then you need SQL Server Replication setting on your both servers either, Snapshot replication, or Transactional replication or Merge replication.

Depending on the replication type, you can start the merge agent whenever you want to syncronize data.

http://databases.about.com/cs/sqlserver/a/aa041303a.htm

Samir R. Ibrahim
Good things Take time, Great things happend all at once.

My WebLog
My Website: www.cdcity.org