Reverse engineered DB, shows changes

jaspernygaard · December 17, 2018 12:24PM

Just reverse engineered a DB into source files and upon recomparing the repo, we get 500+ with differences. Using the PL/SQL Difference Viewer, we see the following characters in the diff in the start of the files:

0A 00

Image: https://us.v-cdn.net/6029854/uploads/editor/3l/6v05gl7orld1.png

I would expect any differences when comparing. Any idea why this is showing up?

Eddie D · December 18, 2018 4:10PM

Hi
Thank you for your forum post.

I suspect it maybe a difference in the character encoding between Carriage Return / Line Feed characters or end of line character in the live schema and the scripts folder.

I can see from the screen shot, the example provided is a Package. Are all the 500 objects reporting a difference Packages? Or are there other object types?

Difficult to see from the screen shot, are there line endings within strings?

Many Thanks
Eddie

Eddie D · December 19, 2018 10:15AM

Hi,

I have one further question. Are there any comments on the 500+ objects listed as different following the refresh of the comparison that takes place after the deployment?

Many Thanks
Eddie

jaspernygaard · December 19, 2018 10:52AM

Hi Eddie, It's different object types - procedures, packages, functions etc. The objects I just looked through in Notepad++ showing all characters, does not show any line endings within strings/comments. And yes the listed objects are the result of recomparing the repository and the source database.

Eddie D · December 19, 2018 2:13PM

Hi,
Thank you for your reply.

Would it be possible to obtain the DDL of one or two of the affected objects to see if we can generate a reproduction of the problem?

Many Thanks
Eddie

Reverse engineered DB, shows changes

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk