About DB update

[phrajib]

I have made an application that is running in 3 different places. Now I need to update my central office database with the change of the other office datas. I have no intranet connection between the offices.

I want to take the other offices DB by floppy/CD or by email. And then want to update my central database according to those databases.

Can you help me?

Can you give me any suggessions related to this ?

For more information I am using Access databases.

Rajib

[dee-u]

Perhaps you need to make a program that would save the records in those databases copied thorugh floppy/cd in your central database.

[phrajib]

Thank you for your cooperation.

If you explain details ( how I can copy new datas to central database) then it can help me more.

Rajib

[dgsatish]

Hi,
How many tables are required to update ?.For this once u r DB copied which is taken from some means of storage(Floopy,CD etc,,).You need to run a programme which should open a connection with this New DB and u r exsting DB,Should cross compare for duplicate records for each table.And finally update the data.Hope u understood or required more.

Satish

[phrajib]

Thanks for all ur help.
I think i understood and can do the job.

If u know how this can be possible in MSSQL SERVER then please help. I think there is no chance to copy DB from one place to another by disks.

Thanks for all your effective suggessions.

Rajib

[dgsatish]

Hi,
I dont have SQL SERVER in my system right now.But you check by right clicking on the table or database,there is import option and fallow the wizard.I think it will help you.

Satish

[Hack]

Thanks for all ur help.
I think i understood and can do the job.

If u know how this can be possible in MSSQL SERVER then please help. I think there is no chance to copy DB from one place to another by disks.

Thanks for all your effective suggessions.

Rajib

Perhaps not by disks, but you can certainly ship databases on CD/DVD's. I get copies of entire SQL Server databases from clients on CDs.

Anyway, once you have the database stored locally, it would be pretty simple to write a quick VB app that connected to both the central database, and the one just received, and run an UPDATE query for existing records and/or and INSERT query for new records.