I’m new to Hubspot development. My company has an instance on hubspot (with a contact database) and wishes to call some hubspot API. For this purpose, I’d like to test the API calls from my application to hubspot. I don’t want to interact with the production instance database during my tests, so I created a development instance through the developers portal. As a consequence, I have a dev database that is decoupled from production database. Until here, eveything’s normal.
Now, I’m wondering how to have the production database schema kept in sync with the development database schema. For example, when someone adds a columns in the production environment, I’d like this change to be applied on the development environment, so that we don’t have to perform the action manually on both environments. This would be a source of error in the future, and that’s why I’d like to do so.
Is there a way to keep in sync the schema of databases in both environments?
At this time, it’s not possible to automatically sync data or settings from a production portal to a developer test portal. Much data can be exported from the production portal and imported into the test portal, however. Settings must be replicated manually.
I certainly see value in the ability to selectively sync data from a production portal to a developer test portal, however. I recommend posting your request on the HubSpot Community Ideas Forum. This information is sent directly to our Product team and helps prioritize feature requests that have the greatest impact on our customers.
Many years later, it now becomes possible to keep two HubSpot accounts in sync with a no-code tool like Stacksync (our product). You can map two HubSpot accounts, data table to data table, and keep them in sync and even trigger data updates based on updates in the source or the destination.
For example, right now it’s not even possible to move data from a HubSpot sandbox account to a production account (though this feature will soon arrive), so a tool like Stacksync can help companies with delpoying updates from their test environment to their production environment.