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.
Please sign in to leave a comment.
Hi
MaintainDB tool allows data copying between any compatible databases.
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?
That's correct.
Connection settings to old database are got from TeamCity Data Directory, and connection settings to target database are provided explicitly.