Best practice for homework

[zab]

Hello

We are working with databases at work. My boss would like to keep working from home so I need a solution. We can work remotely but the server connection is so slow it's hard to generate any script, it just take way too long to interact with the server and it drives us nuts on the long run.

Can you offer your ideas on the best way to do it?

Do I simply use a backup or a clone and make a script to import all the datas?

Thank you.

[comment]

Best practice, IMHO, would dictate getting a faster access to the served solution.

Working with a copy makes sense only if you can guarantee that your boss does not modify existing records or that no one else does while she's working from home. Otherwise you'll be having a synchronization issue - which is likely to be more expensive to solve than the access issue.

[zab]

Yes I'm aware of that. They don't want to pay for a faster server... still need to find the best way to do it.

This is for a special part of the db. He's the only one entering info on that part.

I was thinking of creating a script that made him choose wich client he wants to update, find and import in the 3 diff tables.

DOes it seems good?

[comment]

I cannot give you an opinion based on that description.

[Vaughan]

Ask the same question again, only this time substitute a Word (or Excel) document instead of a database. What would the solution be then?

IMHO either host the database so it is multi-user (and get a decent speed connection) or do the development on a copy and import data from the production system. Heed Comment's advice about the complexities of synchronisation: there is a reason that multi-user databases were invented.

[zab]

OK I'm looking for another solution but I'm not so good in server configurations so I have a few questions.

DO I need FM Server 11 Pro to connect remotely (from home or with Filemaker Go)?

I'm confused. At work or at home I can use fm go on the LAN to connect to the database (fm server 11 at work and fm pro at home) But I can't access through 3G, nor can I use the Internet link to connect from computer at home to work or from work to home.

I authorized port access on my macbook pro os 10.7.1 (hell I even turned the firewall off) I just can't access it.

I give all the access privilege to myself and I also turn on web publishing. It works on LAN not on 3G?

I figured it would be easier to set this up at home first and then on the server. I don't know if port 5003 is open at work I'm waiting for the tech.

Any help, tip, step by step guide would be very much appreciated...

Thanks

[zab]

Ok I found the way to connect through my Time Capsule with port forwarding. Now I need to find the way to do this at my job.

At least I know where the problem is now.

Thanks for your help.

Direct access is no doubt the best solution. And I will find the way to do it.