I just started evaluating the v6 Beta. The first thing I did was to take a database we have that contains about 3400 objects and created scripts. I then compared that physical database (source) with the scripts (target). I didn't expect to find any differences. However, two differences were found. Both were stored procs. In both cases, the body of the stored procs in the target consisted of code that had been entirely commented out (i.e., the stored procs didn't really do anything - all code had been commented out). When v6 scripted these two stored procs, it excluded all the commented out code in the body. Because of this, it determined the two stored procs were not identical with the source.

Randy
randyminder
0

Comments

1 comment

  • Michelle T
    I've done some testing with stored procedures that are entirely commented out, and they save out with the comments in and compare back to the original database with no differences. What style is your code commented out in? (I've tried a variety of commenting styles, but I might just not have got the one you're using.) If you could send the relevant procedures to michelle.taylor@red-gate.com that would be very helpful.
    Michelle T
    0

Add comment

Please sign in to leave a comment.