You are here: Updating online SQL 2005 database from local database « MsSQL Server « IT news, forums, messages
Updating online SQL 2005 database from local database

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация