Using SQL Server 2000 transactional replication which is running continously
to populate our reporting server. We have a thrid party software which we
need to use a interface to take a cvs file and import it into their database.
The interface requires that it has exclusive access to the database. Since we
are running replication there is always a constant connection to the
published database. Is there away to stop that connection. I have tried
stopping the synchronization but it seems to me the only way to remove that
connection is to delete the publiction. Is there an easier way.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200610/1
If the third party software needs access to the subscriber database you
could stop the distribution agent, or have the third party application put
the database in read only or single user mode before it starts to do its
work.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"masmith via droptable.com" <u27472@.uwe> wrote in message
news:680d19bf42976@.uwe...
> Using SQL Server 2000 transactional replication which is running
> continously
> to populate our reporting server. We have a thrid party software which we
> need to use a interface to take a cvs file and import it into their
> database.
> The interface requires that it has exclusive access to the database. Since
> we
> are running replication there is always a constant connection to the
> published database. Is there away to stop that connection. I have tried
> stopping the synchronization but it seems to me the only way to remove
> that
> connection is to delete the publiction. Is there an easier way.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...ation/200610/1
>
Monday, March 12, 2012
Replication Active Connection
Labels:
active,
connection,
continouslyto,
database,
microsoft,
mysql,
oracle,
party,
populate,
replication,
reporting,
running,
server,
software,
sql,
thrid,
transactional
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment