Tech IndustrySep 27, 2022
NewDqAY40

Tool to copy changes to production SQL db?

I'm mainly a programmer with basic SQL experience. Have an online website which uses MS SQL server express db. Every once in a while, I have to alter a table (add fields) but run into the issue where SQL server won't alter unless the table is re-created, which will obviously result in loss of data. Is there a free tool, that can automatically create new tables or alter tables while preserving the data? #sql #sqlserver

Twitter ndvscvs Sep 27, 2022

Idk if this is a good answer, but I've used sequel pro to alter tables.

New
DqAY40 OP Sep 27, 2022

its only for Mac though, I'm working on windows

Amazon TjVI53 Sep 27, 2022

Why do you need a tool, can’t you just run raw SQL against your server?

New
DqAY40 OP Sep 27, 2022

Raw queries will need to be manually updated each time I make changes to a table in dev db and then need to deploy those changes to production, while making sure data isn't lost. Better to use a dedicated tool for that