Splitting table - resultant code didn't include insert
monkeygrind Posts: 40
edited November 29, 2006 4:34AM in SQL Refactor Previous Versions
I split a table and all seemed to be OK, but when I looked at the sprocs that were updated not all statements were affected: the selects were properly updated to use both tables, but not the insert. Also, some of the updates were partially updated. Is this a known issue? I can email the before & after SQL scripts if necessary.
0 · Share on Twitter
this is a know issue and we mention this in the documentation. We also give a warning on the last wizard page if we encounter an insert statement that we cannot rewrite. Some statements cannot be easily rewritten, and many inserts are among these. We are working on a solution.
Red Gate Software Ltd.