Creating Surround SCM database tables

When you upgrade or convert mainline branches or the server database, the physical database and empty Surround SCM tables must be created before the data can be converted. If the tables do not exist, you are prompted to automatically create them. The server loads the corresponding table creation script and sends it to the database server. See Converting the server database to a different type, Copying mainline branches to different databases, and Upgrading mainline branches.

The table creation scripts are stored in the PostgreSQL and SQLServer directories in the Surround SCM Server application directory. DBAs can refer to these scripts when editing database attributes. To learn more, see Installation and upgrades.