Re: Best Practice
From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 08/02/05
- Next message: leslie.causton_at_laserform.co.uk: "Re: sa User is disabled"
- Previous message: Larry Chesnut: "Re: Restricting the use of CTEs"
- In reply to: Ryan: "Best Practice"
- Next in thread: Ryan: "Re: Best Practice"
- Reply: Ryan: "Re: Best Practice"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 2 Aug 2005 18:02:30 +0200
A Scheduled DTS task. But, your table design needs to be able to handle such
a model.
You need a way to identify changed rows and a way to resolve them is they
were both changed between synchronization.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ryan" <Ryan@discussions.microsoft.com> wrote in message
news:4D58A22F-4269-4365-861C-DA7E202EFA04@microsoft.com...
> We have a dedicated web server that runs SQL it is not hosted on our
> network
> it is hosted by an ISP. We also run an inhouse SQL server. We need to get
> info back and forth between the two DB's. What would be the best way to do
> this securely.
>
> Thank you
- Next message: leslie.causton_at_laserform.co.uk: "Re: sa User is disabled"
- Previous message: Larry Chesnut: "Re: Restricting the use of CTEs"
- In reply to: Ryan: "Best Practice"
- Next in thread: Ryan: "Re: Best Practice"
- Reply: Ryan: "Re: Best Practice"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
