Replication

Question

Replication

Viewing 6 posts - 1 through 7 (of 7 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