From SQL Server to Snowflake Cloud with SqlDBM
About the company
Vertical:Digital Content Marketing
Headquarters:Sarasota, FL, USA
Revcontent is a leading content marketing platform run by a small, tight-knit team out of sunny Sarasota, Florida. They connect advertisers to highly engaged audiences through technology and direct partnerships with the world's premier digital publishers.
- Ease cloud migration from SQL Server to Snowflake
- Enforce best coding standards
- Ensure smooth deployments to Snowflake
Doing business at the speed of cloud
When Revconent decided to migrate their warehouse from on-premise to cloud, they searched for a software solution that would guide them through the journey and minimize the manual effort involved. They chose SqlDBM for this mission because of how seamlessly the tool ingested their existing database DDL and how well it integrates with the Snowflake Data Cloud. By performing the migration to Snowflake with the help of SqlDBM, Revcontent began their cloud journey on sound footing -- with a baseline snapshot of their database landscape that could be used to both visualize existing relationships and serve as a reference point for future development. SqlDBM takes care of database-specific properties and formats to make sure that deployed DDL is valid on Snowflake or any other compatible platform.
Continuing the journey with SqlDBM
SqlDBM's central mission is to help customers develop databases online without writing a single line of code. These days, with their tech stack firmly established in the cloud environment, Revcontent focuses on its operational goal of maximizing revenue for digital publishers. However, when a database change is required, Revcontent's development team relies on SqlDBM's no-code visual editor to get the job done.
Through SqlDBM, developers maintain a consistent coding format and can rely on clean, pre-configured naming conventions. Using the forward-engineering feature, Revcontent's developers use SqlDBM to generate table alters which only affect the modified database objects. The tool ensures that there is never a stray comma or missing semicolon, which could derail a critical deployment.