Two cloned databases on the same server - possible interference

[iGor70]

Hi all,

I have a FM Server Advanced 12 Win hosting a large CRM relational database. Since my company recently opened a new unit in a neighboring country I was asked to prepare a clone of the existing CRM for their use.

I intend to run both CRM’s on my server and for this purpose I’ve changed the names of all localized database files. But all the rest (relationship names, Tables names, scripts etc.) will remain the same.

Does anybody know if doing so I’m risking a possible interference between two CRM’s? Is it possible that by mistake a script from one CRM, even if the files have different names, but the structure of files is exactly the same, ends in the other?

Thanks for any advice!

Best regards,

I

[Wim Decorte]

did you use the developer utility to rename the files?  If not then yes, you will risk having the two solutions talk to each other.

[iGor70]

Hi Wim,

Yes, I did. Then I went over all the files step by step to repair the select and close window lines.

[iGor70]

My concern is mainly focused on relationships that have the same names in both CRM's. Does placing the two FM solutions in different folders on the server make any difference?

[Wim Decorte]

No, but since you've used the developer utility (and assuming that you included all the files in the solution) then you should be safe.  The name of the relationship is not important, it is the file reference to the external file.  So you could open each of the renamed file and go to "Manage -> external data sources" to verify that they are all correctly pointing to the renamed files