Activity overview
Latest activity by jregan
is there a support phone number i could talk with someone? i dont think i am doing a good job of explaining my issue here.
I used a migration script because when i checked in my changes, redgate determined that it couldn't do all of the changes and created a migration script. The migration script crated needed to be tweaked as it didn't capture all the changes that were needed. / comments
is there a support phone number i could talk with someone? i dont think i am doing a good job of explaining my issue here.
I used a migration script because when i checked in my changes, redgate d...
sorry, I missed a (very important!) point in my description when I tried to boil down my problem.
There are some tables that have columns dropped as well. ( we redesigned some of our lookup tables, so the structure of a several tables and views has changed and some data is being moved between them)
This was the only solution that I got to work, and i was wondering if there was a better solution....
--this is wrapped up in 1 migration script--
step 1 : create a stored proc that scripts performs some of the table/view changes and moves some data between tables.
step 2: start a transaction,
call the stored proc (from step1),
continue to rest of migration script which alters views, procs
step3: commit transaction then delete the stored proc / comments
sorry, I missed a (very important!) point in my description when I tried to boil down my problem.
There are some tables that have columns dropped as well. ( we redesigned some of our lookup tables,...
modifying table schema and related stored proc in one migration script
I am missing something and could use a little help.
I have 2 migration scripts, that i need to consolidate into 1 script for ease of deploying through multiple environments.
My think problem boils ...