Database Mirroing for back up

[Former Member]

Hi Guys

I have One scenario to develop. I have two diffrent servers one is in Local LAN and the other server is WEB base server. SAP B1 transactions are there on Local LAN server.

My requirement is Whenever a transaction happens in Local Lan, I want to update the same on WEB Base server.

Is there exists any process to update a diffrent database which are not on same server ?

Is there any way to update a database in small increment basis?

Can any one suggest a way to solve this process..

Regards,

Ranjit

[Former Member]

Hello,

>Is there exists any process to update a diffrent database which are not on same server ?

>Is there any way to update a database in small increment basis?

I do not know anything about this procedure. You can try to use with Replication services, from a local database to a remote database, but there are questions related to SAP B1 pacthes (db structure modification goes down to the replicated database?

I am not 100% sure, that you should distribute all the transactions? Even you are sending data to a database which supports web.server data source, you can use openrowset function of SQL.

I mean:

Lan database (= source)

You can filter data changes on source database by Sp_TransactionNotification and log the required business object/transaction types into a custom table.

With openrowset from the remote server / or to the remote server can be distributed by table by table. The point is here you should write the Sql statement depending from the @transaction_type (update close, etc).

This concept does accept any data changes on the target system, which supports web-services.

Here is an very simple example for openrowset.

on Source and target System

1. Start ProgramsMicrosoft SQL Server 2005Configuration Tools Server Surface Area Configuration

2. Click on Surface Area Configuration for Features

3. Click on Ad-hoc Remote Queries and mark "enable OpenRowSet..."

on target System on an SQL Query analizer you can test the remote connection feature:

--Create a structure for Query
select DocEntry, DocNum, DocDate into #t from ordr where 1=2
--insert data from remote server
insert into #t 
select * from 
OPENROWSET( 'SQLoledb',
'server=[SOURCE IP ADDRESS];uid=sa;pwd=[SAPASSWORD]',
'select DocEntry, DocNum, DocDate from SBODEMOHU.dbo.ORDR' )

This sample copies into #t table from the source a result of a specific query from database name SBODEMOHU

I hope it helps,

Regards,

J

Edited by: János Nagy on Feb 23, 2010 3:52 PM

[Former Member]

Hi Jon,

Thankz for your response. But my present issue is, I can be able toconnect to my WEB Server through FTP. How is it possible to send the data from Local server to Web Server.

Is there any process for sending the data in form of packets to get the remote database updated with the incremental transactions?

thanks and waiting for your reply.

[Former Member]

Hello,

I do not know about any method like this.

I think, it is not possible.

Regards,

J.