script new columns as null in dbforge schema comapre

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
nookala82
Posts: 2
Joined: Thu 20 May 2021 15:32

script new columns as null in dbforge schema comapre

Post by nookala82 » Thu 20 May 2021 15:37

I am doing a dbforge schema compare (command line) and there are new columns added to my existing table with NOT NULL. The UI schema compare list those columns and allows user to change them to null but how do we achieve that when executing from command line? Is there a option to script new columns as null and add them to destination table?

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: script new columns as null in dbforge schema comapre

Post by dzhanhira » Fri 21 May 2021 07:28

Unfortunately, there is no such possibility. The functionality of handling this problem presupposes interactive interaction with the user, while the command line presupposes automation.

nookala82
Posts: 2
Joined: Thu 20 May 2021 15:32

Re: script new columns as null in dbforge schema comapre

Post by nookala82 » Thu 27 May 2021 05:20

Please consider this to be an option to be selected by the user in future releases as its available with other tools in the market.

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: script new columns as null in dbforge schema comapre

Post by dzhanhira » Thu 27 May 2021 08:50

You can add every suggestion to our UserVoice https://devart.uservoice.com/forums/772 ... -for-mysql

It can speed-up the implementation process of this option,

Post Reply