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.




How do I move the database from SQL 2000 to SQL 2008?

migration

Our current Gemini 2.2 is running on a SQL Server 2000 database. I'd like to move the database to SQL Server 2008 R2 before upgrading to 4.2.

User54518
· 1
User54518
Replies (3)
helpful
0
not helpful
ANSWER

Backup the database in SQL 2000, restore it to the SQL 2008 server and set the database compatibility mode to 2008 (properties).


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Where is the "database compatibility mode" setting? If the database has a problem the app won't come up so you can't set it via the app. I don't see a setting in web.config unless it's the line: property name="dialect" NHibernate.Dialect.MsSql2005Dialect

Is this what you are referring to?


PaulS
· 1
PaulS
helpful
0
not helpful

It is in SQL manager, not Gemini.


Saar Cohen
· 5000
Saar Cohen