Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Add column from development database table to production database table

I got an issue When some table on the development database has more columns added, and right now I should add the column in the production database.

I try to add the column manually, by Add Column on Table Tree, but when I try to save, it show me a warning:

enter image description here

here's the complete warning message :

Saving Definition Changes to tables with large amounts of data could take a 
 considerable amount of time. While changes are being saved, 
 table data will not be accessible.

is this safe? or is there another method to do this ?

UPDATE : I Tried to click Yes but after some minutes it give me another warning that said Time Out, and the process canceled, and yes the data in the production table is totally huge

like image 811
Sabilv Avatar asked Feb 15 '26 08:02

Sabilv


1 Answers

To fix it, go to the Tools Menu and select Options then under Designers select Table and Database Designers the first option allows you to disable the timeout, or make it greater than the default 30 seconds.

Ref: http://surf11.com/entry/197/saving-table-times-out-in-sql-server-200

like image 81
StackTrace Avatar answered Feb 16 '26 22:02

StackTrace



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!