Splitting table - resultant code didn't include insert
monkeygrind
Posts: 40
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.
Comments
Hi,
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.
Regards,
Andras
Red Gate Software Ltd.