Comments
Sort by recent activity
I maybe should have said: Schema Compare for Oracle version:5.7.8.97 / comments
I maybe should have said:Schema Compare for Oracle version:5.7.8.97
Thank you for your reply. I wonder if the issue does not exist in your system because of the version of Schema Compare that you are using or because of the version of the database. We are using Oracle v19c. We fixed the issue at our end by re-creating the table without any INMEMORY parameters. / comments
Thank you for your reply.I wonder if the issue does not exist in your system because of the version of Schema Compare that you are using or because of the version of the database. We are using Orac...
Hi, I am using version 5.7.8.97 although a colleague is using version 5.7.17.1842 and is getting the same issue. It doesn't produce an error - its just that the script is malformed (and subsequently wont work) / comments
Hi,I am using version 5.7.8.97 although a colleague is using version 5.7.17.1842 and is getting the same issue.It doesn't produce an error - its just that the script is malformed (and subsequently ...
rguser12 said:
I managed to replicate locally the situation with a pound sign.
In fact TextPad does not do as well with encoding support compared to modern editors (for example, Notepad ++)
If you want to execute correctly the script generated by Schema Compare set the environment variable NLS_LANG to the value of .AL32UTF8 before running Sql Plus.
SET NLS_LANG=.AL32UTF8
Then execute the script. Hope this helps.
Many thanks for your help. You are very generous with your time. I think that the problem for me is that the file being produced by SchemaCompare is not in a format that I would like. I think also that this is something that I just have to live with. The issue itself could be as a result of the database being housed on a Linux server and therefore the script could be in a specific encoding or character set. I will probably get round that by running some Powershell Script on the output. / comments
rguser12 said:
I managed to replicate locally the situation with a pound sign.
In fact TextPad does not do as well with encoding support compared to modern editors (for example, Notepad ++)
...
rguser12 said:
What is the encoding of your files? I get such a result when I convert a file from UTF-8 encoding to ASCII. ( '£' => '£')
The file generated from Schema Compare appears to be "UTF-8" . It is also produced using Unix (LF) end of line characters. I believe that we need it to be "ANSI" using Windows (CR LF) for End of line. / comments
rguser12 said:
What is the encoding of your files? I get such a result when I convert a file from UTF-8 encoding to ASCII. ( '£' => '£')
The file generated from Schema Compare appears to ...
I am using Windows 10. I use Schema Compare to Create a Script Folder. I follow all the default steps - this creates a folder structure named after the schema. This folder contains further folders (for each object type) - these now hold scripts for each of the objects. I have a Package Spec that contains a constant which is a pound sign '£'. c_sterling CONSTANT VARCHAR2(1) := '£';The file that has been produced seems to have changed this to '£' - This is only visible in certain editors (e.g. TextPad). However, f I run this script back into the database (for example using SQL Plus) - this line is changed to: c_sterling CONSTANT VARCHAR2(1) := '£';This now means that when this constant is used - it will fail because it has a length of 2 and not 1 as it has been defined. As another annoyance is that the files that Schema Compare produces seem to have a line ending of just LineFeed then the code is unreadable in some editors (such as Notepad). / comments
I am using Windows 10.I use Schema Compare to Create a Script Folder. I follow all the default steps - this creates a folder structure named after the schema. This folder contains further folders (...
David Atkinson said:
Are you using Source Control for Oracle? If you use this, you can make changes directly to the database objects in PL/SQL Developer, and check them in to source control without even having to consider the files at all.
I have looked at Source Control for Oracle. We are currently using TFS more as a backup and not as a release mechanism. When we start to use Source Control as a release pipeline then this might be of more use. / comments
David Atkinson said:
Are you using Source Control for Oracle? If you use this, you can make changes directly to the database objects in PL/SQL Developer, and check them in to source control w...
David Atkinson said:
I'd be curious to know why you have this requirement.
Hi David, We use PL/SQL Developer (from allroundautomations) for our development. This uses a different extension per object type. We will be using Schema Compare to generate the code from our Live database. This will be source controlled. We would then branch from there to a development area. I have taken Alex's suggestion and modified my batch file to change the file extensions from fnc, prc, etc to sql before performing the Compare and then changing them back afterwards. It seems to work fine. Many thanks for your quick response. Terry / comments
David Atkinson said:
I'd be curious to know why you have this requirement.
Hi David,We use PL/SQL Developer (from allroundautomations) for our development. This uses a different extensi...