Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Safe way of Migrating 2.2.6 to 3.1.0

web-app

Dear Community,
Dear Countersoft,

as i failed completely running the upgrade-scripts for an upgrade von 2.2.6 to 3.1.0 i started researching and the only answers i've found so far mentioned problems/solutions/hacks. It did not seem, that any of the suggestions contains a "run this script to get your data from db-a (2.2.6) to db-b (3.1.0)"-solution.

We're using 2.2.6 for quite a while now, so we have a huge amount of data that we would need to take over for a migration. The question, obviously is now: Is there a safe way and how to manage that?

Many thanks for your answers in advance.

Best regards

Crea-Ue. Kirdar

Crea
· 1
Crea
Replies (6)
helpful
0
not helpful

With Gemini 3.x we have introduced a new schema and security model.

This makes the upgrade a bit complicated as the old 2.x database did not have constraints. This is why you have seen people who reported errors during the upgrade. These are not hacks, it is just removing redundant data.

The best way to upgrade, in our optionion, is by backing up your database and running the SQL scripts. If you get an error then it is more than likely to do with data that is redundant and should be excluded.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Hi Mark,

thank you very much for your advice. Unfortunately, i do not see how this is going to help me in this case. I tried running the SQL-Scripts in order to get the Database updated, which resulted in a non-working mixed version with no idea of how to get it done well and stable.

Is there a safe list of which script to execute? IIRC, i got the first error message on the first script already, saying that not all tables are available. Is there maybe a SQL-Script for checking the Database at Version 2.2.6 to make sure, everything is fine for upgrading?

Please excuse me for asking in detail. I'm not very much like an SQL-Idiot or something, it is just that i'm very limited in time i have to get this things up and running. Upgrading my subscription will of course not be necessary, if i can not upgrade from existing database, which might be an idea for CounterSoft to help? No one will transfer the Tasks manually, of course...

Thank you very much again for you help. Any further help would be appreciated of course.

Best regards

Crea-Ue. Kirdar


Crea
· 1
Crea
helpful
0
not helpful

I suggest reading the migration guide: http://countersoft.com/downloads/csfiles/CounterSoftGeminiv310Documentation.zip

This gives you step by step instructions on how to upgrade.

Basically run:

  • CreateTables.sql
  • Createviews.sql
  • CreateProcs.sql
  • Upgradev3-0-Step1.sql
  • Upgradev3-0-Step2.sql

Is that what you have done?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Thanks again!

No, this is actually not what i've done. I ran all files having a number higher than 2.2.6 because i thought, the database would require a Step-to-Step-Migration. I'll read thru that document as soon as i have the time, it's getting late over here and i'm still busy with other things. Thank you very much for the Link, i will try to follow that Guide tomorrow and give you Feedback.

Does that Guide also give instructions about removing the obsolete data or was that, what i've found as "hacks"?


Crea
· 1
Crea
helpful
0
not helpful

Yes, it shows exactly what to do with duplicate types etc...


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Hi Mark,

maybe i should have read that documentation first... However, after i did it like the Documentation advised me to, everything worked fine. Thank you very much again for your time and help.

However, it left me with a very bad feeling about my user migration; so i decided to create a new instance where everything new goes into and leave the other one as archive... i wonder, when my mates from our support-department will ask me for this.

Maybe CounterSoft will think of a little "upgrade.exe" next time, would make things easier and faster...

So far, so good, thanks again.

Crea-Ue. Kirdar




Crea
· 1
Crea