Can we use this task to run Create table scripts to create new table in particular database.

[TanmayNaik17]

Basically i am trying to use this task in CI/CD pipeline that will create new table in database without affecting rest.

[rdagumampan]

Hi @TanmayNaik17 , apologies for delayed response. I think it would be good of you can look at some of our getting started guide and how it works documentation. It may give you some relevant information to help you decide if it fits your use case.

• https://yuniql.io/docs/get-started/
• https://yuniql.io/docs/how-yuniql-works/

With limited information from you, let me try to answer... yuniql doesn't make differential checks when you execute a migration. So in principle, all your existing objects should not be affected. As matter of best practice, we reccomend that you first baseline your schema. Meaning, create the first version of your schema by exporting all the DDL and other relevant sql files to re-create your database locally. Then you can use other tools to perform schema compare to gaurantee that your v0.00 is the same as with your base database.

From there you can create the next version containing your changes. In this case a new table. It's also good practice to ensure that all changes from then on will be based on these migration strategies. Meanining nobody touches the database schema directly :)

HTH / Rodel