Hi All,
We have 3 environments.
1 - Development
2 - Test
3 - Production
I created 2 whole number columns in Development, migrated over to test and then to production, we decided to change the columns from being whole numbers and to decimal numbers instead.
I deleted the columns, moved the solution to test, recreated the columns, moved to test - it all worked, attempted to do the same into Production, moved over the solution with deleted columns, worked. Tried to move over the second solution with the remade columns (same names) and it errored out. The columns from the first solution still exist on the User table and are unable to be deleted.
My questions are as follows:
- Why did the testing environment let me delete columns, migrate solution, recreate columns and migrate solution and work?
- Why does the production environment not allow the same actions
- Is there a way to delete these columns from the Production User table so they can be replaced with the decimal number equivelants?
I understand I could just rename the columns but now I have redundant columns created on the user table I am unable to delete and I would prefer it to be cleaned up.
Thanks in advance!
