Migrate DB from SQL Server to PostgreSQL ...

[ThierryF]

Hello,

Due to SQL Licensing costs and our Backup server's CPU HW (2 CPU of 20 Cores each) from a side and
our Veeam SQL DB Size (+14GB) preventing SQLExpress usage,
I have been requested to search for a solution and the one that poped-up is migrating our
server's SQLServer based Configuration DB (VBR 12.3.2.4165) to PostgreSQL.

For what I analyzed and found till now and if I am correct (if not please correct me), migration steps should be to
- Stop and disable all veeam jobs
- Take Veeam Backup of config (vbo)
- Restore backup (https://helpcenter.veeam.com/archive/ba ... resql.html) choosing migration
- Reactivate all veeam jobs

What about the job history, will they also be included in "migration" and not be lost ?

Any other points to take attention to I could have missed ?

Thanks for your inputs and/or experience sharing

Th

[vnikiforov]

Hello,

This process is pretty much straightforward at this point. You mentioned the correct User's guide section to perform that.
Everything will be migrated, including job history.
Make sure you perform these actions in the "important" note Setting PostgreSQL configuration
You most probably also need to perform these changes to authenticate the account used for migration SSPI auth
If you face any difficulties in the process, please open a support case. On this forum, we can not deal with technical issues.