Migrating to SQL Server: table prefix

Hello, long term user, first time poster here.

I'm migrating TC from HSQL2 to SQL Server and I was wondering whether it is possible to prefix all the TC tables in my database? (e.g. TC_db_version, TC_project_files, TC_usergroup_users, etc, etc)

We've got an IT "issue" in that they are only allowing us 1 DB for our team (for now), so we are having to prefix the tables in the DB so we can relate the tables to our specific apps.

Any help would be appreciated.

Paul

1 comment
Comment actions Permalink

Hi Paul,

No, it is not possible to rename databases used by TeamCity. TeamCity should use a separate database schema. However you can install TeamCity schema in a shared table space. TeamCity never attempts to access other schemas even if they are accessible.

0

Please sign in to leave a comment.