Monday, March 19, 2012

How to easieast way Incremental Backup of SQL Database?

Hi!
We have database which we are continuously updating, and also providing to
our client. And our client also using our database and updating at their
end. We want to give next update as a Incremental only so that our changes
should be given to them and their changes also should be remain there in
their database.
Is there any way to provide Incremental Database?
Thanks
Anil Lakhani
Message posted via http://www.sqlmonster.com
Do you mean data or schema changes ?
If you mean data, then a merge replication solution may work, although you
will need to consider conflict resolution for changes made at the client
that you also make.
If you are talking about schema changes, then you will need to write custom
scripts for this, especially if you are unsure about what changes have been
made at the client site.
Regards,
Rod Colledge.
"Lakhani Anil via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:232d63e246b74a4eb2065d9bd1f26e9d@.SQLMonster.c om...
> Hi!
> We have database which we are continuously updating, and also providing to
> our client. And our client also using our database and updating at their
> end. We want to give next update as a Incremental only so that our changes
> should be given to them and their changes also should be remain there in
> their database.
> Is there any way to provide Incremental Database?
> Thanks
> Anil Lakhani
> --
> Message posted via http://www.sqlmonster.com

No comments:

Post a Comment