SQL Server Forums - replication remote client need help indeed

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2008 Forums

Replication (2008)

replication remote client need help indeed

New Topic

Reply to Topic

Printer Friendly

Author

Topic

radius888
Starting Member

Indonesia
2 Posts

Posted - 08/03/2012 : 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

USA
4965 Posts

Posted - 08/04/2012 : 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

radius888
Starting Member

Indonesia
2 Posts

Posted - 08/06/2012 : 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

russell
Pyro-ma-ni-yak

USA
4965 Posts

Posted - 08/07/2012 : 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.

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.