4 ms·

We use managed services, but only those that are managed versions of pre-existing software. For example, we'll used Managed Postgres, but not Azure or AWS's ho

We use managed services, but only those that are managed versions of pre-existing software. For example, we'll used Managed Postgres, but not Azure or AWS's home grown databases. Makes migrating much easier.

withinboredom 2y ago
Heh, until you need to rollback a specific table in postgres using their backup solution. IIRC, this is possible in AWS -- or at least, I'm 99% sure you can at least download the backup. In Azure? All you can do is restore the entire database, and you cannot download it.
- seper8 2y ago
  You can def download it
  - withinboredom 2y ago
    Not in my azure portal.
  - tanseydavid 2y ago
    >> You can def download it I would love for you to briefly describe how and where this can be done. I wasted a significant amount of time searching for this exact capability for Azure SQL Database and only ran into dead-ends.
    - tremon 2y ago
      For Azure SQL Database, you can restore any database backup to a new database, and export any existing database to bacpac format on a storage account [0]. The storage account file can be downloaded. You can also do the latter without using through the portal, using sqlpackage.exe on your local machine (same restriction applies: sqlpackage must connect to a live database, so if you want to download/view an Azure backup you must first perform a backup restore). Not sure how to do the same for Azure Postgresql databases, but looks like standard pg_dump and pg_restore are supported. [0]: https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export?view=azuresql https://learn.microsoft.com/en-us/azure/azure-sql/database/d...
conradev 2y ago
Yes! The longer response is that the closer you stick to standards the easier of a time you will have. VMs are a standard with cloud-init and image formats, etc. i.e. in 2025 managed Kubernetes is not _that_ different between providers

withinboredom 2y ago

Heh, until you need to rollback a specific table in postgres using their backup solution. IIRC, this is possible in AWS -- or at least, I'm 99% sure you can at least download the backup. In Azure? All you can do is restore the entire database, and you cannot download it.

seper8 2y ago
You can def download it
- withinboredom 2y ago
  Not in my azure portal.
- tanseydavid 2y ago
  >> You can def download it I would love for you to briefly describe how and where this can be done. I wasted a significant amount of time searching for this exact capability for Azure SQL Database and only ran into dead-ends.
  - tremon 2y ago
    For Azure SQL Database, you can restore any database backup to a new database, and export any existing database to bacpac format on a storage account [0]. The storage account file can be downloaded. You can also do the latter without using through the portal, using sqlpackage.exe on your local machine (same restriction applies: sqlpackage must connect to a live database, so if you want to download/view an Azure backup you must first perform a backup restore). Not sure how to do the same for Azure Postgresql databases, but looks like standard pg_dump and pg_restore are supported. [0]: https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export?view=azuresql https://learn.microsoft.com/en-us/azure/azure-sql/database/d...

conradev 2y ago

Yes! The longer response is that the closer you stick to standards the easier of a time you will have. VMs are a standard with cloud-init and image formats, etc. i.e. in 2025 managed Kubernetes is not _that_ different between providers