Prev: Select statement comparing a uniqueidentifier field
Next: Can a relationship contain a literal constraint?
From: DotNetKanna on 23 Jul 2008 03:30
Hi all,
Im using two database db1,db2, the data will be insert,update will done in db1 will be uploaded once in a day.if i updated or inserted the records in another day means it should fetch that records alone and updated to db2 database,im using sql server 2000,asp.net2.0.how can i acheive this one.

Regrds
Kanna
From: dave ballantyne on 23 Jul 2008 03:42
DotNetKanna . wrote:
> Hi all,
> Im using two database db1,db2, the data will be insert,update will done in db1 will be uploaded once in a day.if i updated or inserted the records in another day means it should fetch that records alone and updated to db2 database,im using sql server 2000,asp.net2.0.how can i acheive this one.
>
> Regrds
> Kanna


Have you ruled out replication ?

Dave
From: Eric Russell on 23 Jul 2008 09:48
To begin with, basically, what is the purpose of database #2 ?
For example: Backup, read only reporting, QA testing, etc.
- Is database #2 on a different server?
- Is it OK that database #2 by kept in read-only mode?
- Is it OK that database #2 be offline for a brief period of time during the
refresh process?

There are several standard and effective methods to accomplish this, each
with their own pros and cons. However, none of them involve ASP.NET. Your
chosen method should be implemented entirely on the database server and
transparent to the application and web server.

Also, here is a really good article that summarizes the alternatives and
issues:
Standby Servers: Log-Shipping vs Transactional Replication vs Database
Mirroring
http://www.replicationanswers.com/ReplicationLogShippingMirroring.asp


"DotNetKanna ." wrote:

> Hi all,
> Im using two database db1,db2, the data will be insert,update will done in db1 will be uploaded once in a day.if i updated or inserted the records in another day means it should fetch that records alone and updated to db2 database,im using sql server 2000,asp.net2.0.how can i acheive this one.
>
> Regrds
> Kanna
>
 | 
Pages: 1
Prev: Select statement comparing a uniqueidentifier field
Next: Can a relationship contain a literal constraint?