Posted by John Morgan on 01/30/07 10:32

I have my first small SQl Server 2005 database developed on my local
server and I have also its equivalent as an online database.

I wish to update the local database (using and asp.net interface) and
then to upload the data (at least the amended data, but given the
small size all data should be no trouble) to the online database.

I think replication is the straight answer but I have no experience of
this and I am wondering what else I might use which might be less
complicated. One solution is DTS (using SQL 2000 terms) but i am not
sure if I can set this up (1) to overwrite existing tables and (2) not
to seemingly remove identity attributes from fields set as identities.

I know there are other possibilities but I would be glad of advice as
to the likely best method for a small database updated perhaps once
weekly or at less frequent intervals,

Best wishes, John Morgan

[Back to original message]