Possible to migrate from SQL server to postgres?

We're considering migrating from an on-premises installation of TeamCity to one that runs inside AWS.  We currently run on Windows + SQL Server, and we're looking at migrating onto a flavour of Linux and MySQL (AWS::RDS) or PostGres (running on an EC2 instance that we'd manage).

Looking at the external database support, the platform is supported - but is it possible to migrate the data using the maintainDB script that TeamCity ships with?  The documentation isn't clear to me.

3 comments
Comment actions Permalink

Hi

MaintainDB tool allows data copying between any compatible databases.

0
Comment actions Permalink

Thanks!

So I should create a SQL Server backup (using maintainDB or the web UI), create a new database.properties file to target the different database and set up its driver, then run "maintainDB migrate -A <path to TeamCity Data Directory> -T <path to database.properties file>" basically?

0
Comment actions Permalink

That's correct.
Connection settings to old database are got from TeamCity Data Directory, and connection settings to target database are provided explicitly.

0

Please sign in to leave a comment.