Jump to content

Update remote database


Warcken
 Share

This topic is 7195 days old. Please don't post here. Open a new topic instead.

Recommended Posts

We have a database with 9 related files, many scripts, etc. We have an office on each coast. Is there a way that we can update each other periodically? This would mean that if someone here (or there) added a new record, a comment or any other information to any of the files, the database at the other location could also obtain this information. I'm guessing there are probably multiple ways of accomplishing this. We need a secure method that doesn't require a big investment and is also easy to use (if there is such a thing).

Thank you.

Link to comment
Share on other sites

Safest method is to have server on one location and the other end will just connect through TCP/IP.

It depends on structure and number of users, but you can start with 128k lines for 2-5 users.

FM is just sending smallest possible amounts of data. No fancy graphic on layouts! Only FM vector graphic is recommended.

Link to comment
Share on other sites

quote:

Originally posted by DWarcken:

Thank you for your reply.

We have someone working on this. I have been reading some other threads, as well. At issue currently are security (of course) and the fact that both locations are using a dsl connection. Any suggestions, warnings, etc. are appreciated. There will be only one remote user. The layouts are basic FileMaker layouts (no pictures except for our logo on one). There are portals, scripts and buttons (lots of buttons).

You may want to trim back on the buttons especially if they were not amde with the utton tool.

Also, you are very correct about security. Be sure the files have very good security schemes in place.

See the security link at

http://www.FMP-Power.com for added info on security.

Old Advance Man

Link to comment
Share on other sites

Thank you for your reply.

We have someone working on this. I have been reading some other threads, as well. At issue currently are security (of course) and the fact that both locations are using a dsl connection. Any suggestions, warnings, etc. are appreciated. There will be only one remote user. The layouts are basic FileMaker layouts (no pictures except for our logo on one). There are portals, scripts and buttons (lots of buttons).

Link to comment
Share on other sites

Even on a limited use basis, is it possible that two or more users would be online at the same time. If so then running scripts can be a problem. You will find adequate discussion about scripts on the cdml forum.

As far as I know, I am the originator of and only one in the world with a workaround to the script problem. I will be making a site available next week (if all goes according to today's plan) which will demonstrate the success of my workaround.

Link to comment
Share on other sites

Keith, I was under impression, that it will be FM to FM communication. In that case no problem whatsoever.

If the communication will be through Browser and Instant Publishing, then security must be tighter especially in all databases. Instant Publishing also doesn't work fully as client.

I'll suggest going for FM client on the remote side.

Link to comment
Share on other sites

This topic is 7195 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.