Using SQLServer 2005

We are starting a 3.0 environment and cannot use MySQL as a database (was a stretch to allow Tomcat). I downloaded the JDBC for SQLServer 2005 and attempted to run the script. As it errored out (could not access file buildserver.script), I simply opened it and ran the script within the Management Studio to create the tables. However, the application does not seem to function.

We reverted to using the out of the box database and it works fine. As we have not done anything within the system as of yet, I can uninstall and reinstall and provide the exact errors and messages as necessary.

I was wondering if anyone used SQL 2005 (or 2000 for that matter) with Team City successfully? If so, how did you install it?

Thank you in advance.

1 comment

Stephen wrote:

We are starting a 3.0 environment and cannot use MySQL as a database (was a stretch to allow Tomcat). I downloaded the JDBC for SQLServer 2005 and attempted to run the script. As it errored out (could not access file buildserver.script), I simply opened it and ran the script within the Management Studio to create the tables. However, the application does not seem to function.
We reverted to using the out of the box database and it works fine. As we have not done anything within the system as of yet, I can uninstall and reinstall and provide the exact errors and messages as necessary.
I was wondering if anyone used SQL 2005 (or 2000 for that matter) with Team City successfully? If so, how did you install it?
Thank you in advance.


*SQL Server dialect is not supported and neither version will work with
TeamCity.*

Currently supported databases are
HSQL: built-in, targeted for evaluation
MySQL: fully tested and actually heavily used in production environments
PosgreSQL: is actually targeted to support environments where MySQL can
not be run such as AIX

There are plans to support Oracle and Sybase in releases after 3.0

You may create request for SQL Server support in out Jira and watch for
its progress.

--
Alexey Gopachenko
JetBrains Inc.
http://www.intellij.com
"Develop with pleasure!"

0

Please sign in to leave a comment.