Production DB vs Developer DB

[nunomedeiros]

Hi,

I need to know how to solve the problem of having a production DB (Runtime)and have to upgrade that DB with a new version that came with new layouts and more scripts without losing or have to export/import all the records to the new version.

thanks

[Steven H. Blackwell]

quote:

---

Originally posted by Nuno Medeiros:

Hi,

I need to know how to solve the problem of having a production DB (Runtime)and have to upgrade that DB with a new version that came with new layouts and more scripts without losing or have to export/import all the records to the new version.

thanks

---

Well, this is an interesting issue. And it holds true for a runtime engine or for regular FileMaker Pro itself.

This is a question of file architecture. You would have needed at the outset to have separated Interface from Business Logic from Data. That way you can replace the UI files and the Business Logic files without having to replace the data files.

This is not easy to do. This topic was covered in some detail at the FileMaker Developer Conference several months ago. I imagine we will do it again next year.

HTH

Old Advance Man

[nunomedeiros]

So how do you think it is the best way to do that?

[Anatoli]

OAM posted:

This is a question of file architecture. You would have needed at the outset to have separated Interface from Business Logic from Data. That way you can replace the UI files and the Business Logic files without having to replace the data files.

What is in that you do not understand?

BTW, with this style of programming you can speed up your WAN especially if it runs over 60-128k lines, which is quite common here in East Europe.

[nunomedeiros]

quote:

---

This is a question of file architecture. You would have needed at the outset to have separated Interface from Business Logic from Data. That way you can replace the UI files and the Business Logic files without having to replace the data files.

What is in that you do not understand?

---

I understand this issue. My question is: What is the best way to solve that?

[Steven H. Blackwell]

quote:

---

Originally posted by Nuno Medeiros:

I understand this issue. My question is: What is the best way to solve that?

---

There really isn't a direct fix to this. There is an indirect one. But the only direct fix that I know would be for you to have constructed the files differently from the outset.

Old Advance Man