What are the challenges you face when working across database platforms? Take the survey
Options

Splitting table - resultant code didn't include insert

monkeygrindmonkeygrind 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.

Comments

  • Options
    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.

    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
    András Belokosztolszki, PhD
    Red Gate Software Ltd.
Sign In or Register to comment.