A customer asked me to replicate his solution into three (he owns 3 very similar companies and he wants to keep all data separated).
Created a new Sybase db
Put it in sybase.config
Created the db connection
Exported the original solution
Disabled the original db connection
Chose CLEAN IMPORT and gave the solution a different name
Chose the new db connection
I did it twice, on my laptop, with no problem.
When I went to the customer, I realized that one of the new solutions needed some data from the old one, so I created an empty db and exported the original solution with sample data. Apart of this, all the steps were the same I described above BUT…
The new solution imported fine, with no errors, but every portal in the solution lost its relation.
The field were there, the data were in the right place, but the portal was linked to no relation.
Reassigning it manually brought it back to work.
Anyway, it’s a very dangerous behaviour (especially if the developer doesn’t get any error, when importing).
I’m not sure I can reproduce it (as I wrote, I did it twice the day before and all went fine). But I think it’s worth of further investigation.