 Re: Updating an Instance from the production database -
05-28-2008
, 01:27 PM
I think you are using terms incorrectly. Any installation of SQL Server is
an instance. You can have a named instance or a default instance. You can
have several instances on a server, but only one of them can be a default
instance.
That said, it appears that you want to keep 2 DB's in synch. Consider
transactional replication. The prod DB would be the publisher and the other
DB would be the subscriber.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Hoardling1 via SQLMonster.com" <u43783@uwe> wrote
I am currently using SQL Server 2000. I have a production database and an
instance. The instance is mainly for web display. What I would like to do
is when the production database has an insert or update a trigger, or any
other option, activates and inserts or updates the instance database
immediately. I am mainly looking at this process, but if anyone has any
other ideas I am willing to listen. I have thought about DTS and doing
truncate then copy the database into the set, but clearing and copying seems
like a lot of overhead.
--
Message posted via http://www.sqlmonster.com
 |
Linear Mode
