Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 replication remote client need help indeed

Author  Topic 

radius888
Starting Member

2 Posts

Posted - 2012-08-03 : 08:37:43
I have two different computer with two different place

both of that computer using dbase as database ...

how to replication both of database using sql server 2008 and linked server ?

what kind of tools if there is some additional tools ?

do anybody here can explain to me step by step, i really need it and i willing to pay also for consultation fee after this project done .

Radius erwin da silva

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-08-04 : 08:30:25
Can't use replication for dBase, but you can use SSIS.

Might have a look at this: http://msdn.microsoft.com/en-us/library/aa337084.aspx

And this: http://timothychenallen.blogspot.com/2007/07/how-to-import-dbase-tables-into-sql.html
Go to Top of Page

radius888
Starting Member

2 Posts

Posted - 2012-08-06 : 05:49:20
Hi russell , i already installed ssIS and can do import oledb data dbf ... how to configure replication with ssis ? can you explain to me step by step ? what toolbox i must choose and how to real time connect between two data. ?


Radius erwin da silva
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-08-07 : 11:04:26
Replication and SSIS are two different tools.

You aren't going to get real time synchronization, but you can create a SQL Agent job to execute your SSIS package(s) to import the .dbf as often as you need, giving you near real time.
Go to Top of Page
   

- Advertisement -