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.




Move DB from MySQL to SQL Server

web-app

We currently have our Gemini installation on our office server, but now wish to move it to our Internet Web Server.

Currently it is running on MySQL, but we want to move it to SQL Server 2005. I can manage to move the web files, transfer the data, etc but I wanted to check what settings may need to be changed. Obviously, the data connection details but what else?

Also, do I just edit them manually or go through a normal "install" and then copy the data over the top?

Any advice, etc, most welcome!!
ascend
· 1 		ascend
Friday, May 5, 2006, 11:30:32 AM
Replies (2)
helpful
0
not helpful

Not sure how you run Gemini on MySQL! must be MSDE.

You can do a new install or copy the web files, up to you really but there is no differecne.

The changed in the web.config should be:

  • Connection string
  • FullGeminiURL
  • If you are using SQL server state, then change that connection string as well as creating the database.
  • SMTP server if this has changed 
Saar Cohen
· 5000 		Saar Cohen
Friday, May 5, 2006, 9:05:27 PM
helpful
0
not helpful

[quote user="SaarCohen"]

Not sure how you run Gemini on MySQL! must be MSDE.

[/quote]

Oops! Actually, it's already on SQL Server (2000)! It's been a tough day, that's my excuse ;-)

Anyway, thanks for the info ... it all sounds nice and easy!
ascend
· 1 		ascend
Saturday, May 6, 2006, 12:44:30 AM