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.




Order of scripts when doing an upgrade from 2.0.5

web-app

When doing an upgrade from 2.0.5, do you run the 5 scripts and THEN the upgrade Upgradev2-1.SQL?  Should I be running the first 5 for an upgrade?

1. CREATETABLES.SQL
2. CREATEVIEWS.SQL
3. CREATEPROCS.SQL
4. InstallCommon.SQL
5. InstallProfile.SQL
6. Upgrade_v2-1.SQL
cromwellryan
· 1 		cromwellryan
Tuesday, April 24, 2007, 4:00:33 PM
Replies (6)
helpful
0
not helpful

No, you need to run 6 followed by 2, 3, 4 and 5.

Do NOT run 1 (create tables), it will remove all your data.

 
Mark Wing
· 9108 		Mark Wing
Tuesday, April 24, 2007, 4:05:21 PM
helpful
0
not helpful

Awesome - thanks for the quick response.

In the readme.txt it states that "the INSTALLxxx.SQL SCRIPTS WILL CREATE A NEW ASPNET DATABASE IN YOUR SQL SERVER INSTANCE" but I see that that portion of the InstallCommon.sql is commented out.  Why is this?  Do I need to do something here?
cromwellryan
· 1 		cromwellryan
Tuesday, April 24, 2007, 4:13:34 PM
helpful
0
not helpful

We have decided against auto create of the profile database. Giving the person who installs the option to run these on any database they wish. Just make sure to set the connection strings in the web.config file (1 for Gemini and 1 for the profile).
Mark Wing
· 9108 		Mark Wing
Tuesday, April 24, 2007, 4:18:28 PM
helpful
0
not helpful

Great - thanks for the help.  Hopefully it will all go smoothly.
cromwellryan
· 1 		cromwellryan
Tuesday, April 24, 2007, 4:36:13 PM
helpful
0
not helpful

Does this mean that the Profile database can be installed within the main database (ie just have one single database?)
Simon@MailboxPro
· 1 		Simon@MailboxPro
Sunday, June 3, 2007, 5:42:40 PM
helpful
0
not helpful

Yes, it is your choice. Just make sure you set the profile connection string in the web.config file.
Saar Cohen
· 5000 		Saar Cohen
Sunday, June 3, 2007, 8:32:24 PM