Using Liquibase with SAS

[AllanBowe]

Does anyone have any experience, tips or suggestions for using Liquibase to manage SAS tables?

Am guessing an approach would be to use the h2 database, write changes in YAML or XML, and generate DDL in some SAS friendly format (Postgres? SQL Server?)

[r2liquibase]

I'm on the Liquibase team and I am *very* intrigued by this. I haven't used SAS since my undergrad days, but we'd love to help with this.

I think you're on the right track to manage the underlying database that supports SAS. But, I'm sure there are a ton of gotchas ahead. It's pretty easy to get in touch with someone on the team to ask questions: https://www.liquibase.org/contact. 

Thanks!

Robert

[AllanBowe]

I sent a mail - thanks for the follow up!

[VincentRejany]

Hi Allan

Would be interested in hearing about the use case. As we are working on SAS Studio it could be interesting to investigate an integration with Liquibase

[AllanBowe]

Indeed, that would be great. What is really needed is for a java developer to write the requisite connector so that the liquibase control tables could be held as SAS datasets, and the relevant conversions applied.

In the meantime I'm using the H2 database, changesets in YAML, and generating SQL change scripts. Just getting started with it, will write up my approach in the next week or two