how can i rerun the sql script using DbUp with new modifications?

Question

Hello

I am new to using DbUp and when I run a script it runs successfully but when I add some modifications I get this message

Beginning database upgrade

Checking whether journal table exists..

Fetching list of already executed scripts.

No new scripts need to be executed - completing.

Success!
ex:
now I have this code

CREATE TABLE domain.StoreAdmins(

AdminId INT,

StoreId INT,

AdminName NVARCHAR(255) NOT NULL,

AdminEmail NVARCHAR(255) NOT NULL,

AdminPhoneNumber NVARCHAR(20) NOT NULL,

PRIMARY KEY(AdminId,StoreId),

);

then I run the database

and I have changed it to be
CREATE TABLE domain.StoreAdmins(

AdminId INT,

StoreId INT,

AdminName NVARCHAR(255) NOT NULL,

AdminPhoneNumber NVARCHAR(20) NOT NULL,

PRIMARY KEY(AdminId,StoreId),

);

when I run again I got the message up

Answer

Hi @Saleh Salem

No new scripts need to be executed - completing.

How about adding ALTER like this:

CREATE OR ALTER TABLE domain.StoreAdmins(
AdminId INT,
StoreId INT,
AdminName NVARCHAR(255) NOT NULL,
AdminPhoneNumber NVARCHAR(20) NOT NULL,
PRIMARY KEY(AdminId,StoreId),
);

Best regards,

Cosmog

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Share via

how can i rerun the sql script using DbUp with new modifications?

1 answer

Your answer