Lukket

Fazer projeto de rede SQL SERVER entre varios terminais SERVER <> Terminal1 <> Terminal2

Tenho a conexão no modo de publicação de dados entre SQL SERVER e Terminal.

So o problema e monitorar a conexao no caso e dar a prioridade de conexão.

Tanbem precizo disparar o monitor tanto no servidor quanto no terminal

o Codigo Exemplo que tenho e este.

' Define the server, publication, and database names.

Dim subscriberName As String = subscriberInstance

Dim publisherName As String = publisherInstance

Dim publicationName As String = "AdvWorksProductTran"

Dim subscriptionDbName As String = "AdventureWorks2012Replica"

Dim publicationDbName As String = "AdventureWorks2012"

' Create a connection to the Publisher.

Dim conn As ServerConnection = New ServerConnection(publisherName)

Dim subscription As TransSubscription

Try

' Connect to the Publisher.

[login to view URL]()

' Instantiate the push subscription.

subscription = New TransSubscription()

[login to view URL] = conn

[login to view URL] = publicationDbName

[login to view URL] = publicationName

[login to view URL] = subscriptionDbName

[login to view URL] = subscriberName

' If the push subscription and the job exists, start the agent job.

If [login to view URL]() And Not [login to view URL] Is Nothing Then

' Start the Distribution Agent asynchronously.

[login to view URL]()

Else

' Do something here if the subscription does not exist.

Throw New ApplicationException([login to view URL]( _

"A subscription to '{0}' does not exists on {1}", _

publicationName, subscriberName))

End If

Catch ex As Exception

' Implement appropriate error handling here.

Throw New ApplicationException("The subscription could not be synchronized.", ex)

Finally

[login to view URL]()

End Try

Precizo monitorar a conexao dos dois lados e tanbem para ser em linguagem vb.net

Evner: .NET, Microsoft SQL Server, MySQL, SQL, VB.NET

Se mere: configure sql xml support iis window 2003 server, sql 2005 automate backup database 2003 server, fazer projeto e designer ambiente on line

Om arbejdsgiveren:
( 2 bedømmelser ) Castelo dos Sonhos, Brazil

Projekt ID: #18129551

2 freelancere byder i gennemsnit $147 på dette job

godofbid

Oi. Sou o primeiro a assinar site freelancer, mas sou Desenvolvedor Sênior com mais de 5 anos de experiência. Eu tenho experiência de trabalho Semelhante ao seu projeto, então eu acho que este projeto realmente se ad Flere

$138 USD in 3 dage
(0 bedømmelser)
0.0
goshavart

Здравствуйте. Могу выполнять разовые работы. В качестве примера возможностей приведу разработку не имеющую аналогов в мире. [login to view URL] [login to view URL] Flere

$155 USD in 10 dage
(0 bedømmelser)
0.0