Moving from SQL development to SQL live database.

[JHaughey]

  Working on a project right now involving SQL ESS tables which are drawn from the client's development database. When it comes time to deploy and move to the live database, is it just matter of repointing the existing DSN to the correct place?

 

  I've just had this nightmare vision where I'm re-connecting everything, but that can't be the way it works, because the universe just can't be that cruel, can it? CAN IT?? 

[NYPoke]

Set up a similar SQL Process.  Redirect the ODBC Driver, assuming that is the connection, and FileMaker should be fine.

 

Might try to do a  Sync on the linked tables & make sure it all matches.  As long at the SQL DDL is the same, it is that easy.