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
Why do you need a tool, can’t you just run raw SQL against your server?
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
World Conflicts
Yesterday
485
Why I Find Free Palestine Inspiring
World Conflicts
Yesterday
639
Israeli precision-guided munition likely killed group of children playing foosball in Gaza, weapons experts say
India
Yesterday
679
'Hindutva': The Radical Hindu Ideology That Seeks to 'Push Christianity Out of India’
Tech Industry
Yesterday
1778
Do people underestimate E6 role at meta?
Tech Industry
3d
15404
RIP Google Core Employees replaced with Mexico and India Workers
Idk if this is a good answer, but I've used sequel pro to alter tables.
its only for Mac though, I'm working on windows