Replication

Question

Replication

sqlpro

Hall of Fame

Points: 3859
More actions
December 30, 2003 at 4:57 pm

#161283

Dear friends
need some idea on replication.
we have an application in our office MSDE8 as backend and visual foxpro as frontend.now
we want to enable replication.i mean users can take our application on their laptop and do some changes to data in offline mode.when they relogin to our main database server we need to update latest data from laptop.
its a new concept for me
i wonder if u could suggest any article or some sort which get me some idea on this issue.
my initial idea is to install MSDE on every laptop that'll b going offline and copy data from main server to these offline databases.
once they relogin to main server then i need to write a program that transfers newly added data /modified data to main database server.
am i going right way?
thank you so much for ur suggestion.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

ThomasH SSCertifiable Points: 7437 More actions · Answer 1

If you can get the xBase data to the server, then you could use OPENROWSET, OPENQUERY to directly read the DBF data in T-SQL.

I use T-SQL & COM to create DBF files for the mobiles to "pickup",

the mobiles also "deposit" DBF files, and I use T-SQL to read in this DBF data.

FYI, I'm using FoxPro DBFs.

Once you understand the BITs, all the pieces come together

sqlpro Hall of Fame Points: 3859 More actions · Answer 2

thank for ur reply thomas.

in my case our frontend application programmed to interact with sql server only

not .dbf files.

seems like correct me if i am wrong,

if i were 2 follow ur suggestion i need 2 reprogramme our whole frontend application.

right?

by the way i could not understand xBase data u mentioned in ur reply.

Thanks

ThomasH SSCertifiable Points: 7437 More actions · Answer 3

You mentioned "visual foxpro" in your initial post.

Is your visual foxpro frontend accessing simple (DBF)

or compound "foxpro native" databases?

Once you understand the BITs, all the pieces come together

sqlpro Hall of Fame Points: 3859 More actions · Answer 4

our frontend application accessing sql server database not vfp tables.

we r using vfp just as frontend .

ThomasH SSCertifiable Points: 7437 More actions · Answer 5

We have alot of different mobile applications communicating data to and from SQL Server.

Some of the apps use DBFs, SQLCE, and MSDE.

I do not use replication because of lack of control (In my opinion).

The mobile devices connect, and deposit data, sometime directly into SQL Server, then

they "download" data, then disconnect.

SQL server then is triggered to process in the deposited data, and at other times prepares data to send to the mobile device upon next connect.

Replication might be great for you, but I could not use it effectively in my senarios.

Perhaps there are some others in this forum with replication experience.

Once you understand the BITs, all the pieces come together

sqlpro Hall of Fame Points: 3859 More actions · Answer 6

actually we did not design our application initially keeping replication in our mind.

we needed it now bcoz

my boss who travels extensively and always uses this application.

ofcourse he could connect to sql server from anywhere thr internet connection and update data and which he's been doing.

but sometimes in some places there wont b internet connection.

so what he wants is he'll enter/update data in his laptop and when he connects to sql server (which sits in our office)the data he modified should be updated.

i am wondering how 2 make that happen.

i believe u get the idea ,right thomas?

cheers