I am not an expert on db desigen although I have created a few using sql server 7 enterprise manager. I have deployed them and so far working with no problems at all. I also use coldfusion for web dev.
I have recently switched to the Mac world and I do like it so far, my main problem is the db managment system, i was not able to find something as easy as the enterprise manager!!
I came accross FM7 a few days ago, and it seems interesting, especially as a db on a local mach. since some of our application would require that the db is on a local network! and it seems that one can easily incroporate data from the db to track records and send e-mails.
My question is:
1- if one uses FM to desigen a db can one then upload this to an online sql server (the one on the hosting company, where the users enter the records themselves)?
2- would one be able to syncronize between the two db's?