I am running SQL Packager 220.127.116.11. What I am doing is using Packager to generate schema and data SQL scripts that are deltas from our deveploment and testing databases for change management purposes and troubleshooting. During the script creation process we are appending the delta scripts to a master script file that contains all database changes for each build. This is so that when we need to create the environment to a specific build level, we can highlight all the code that we want (leaving out what we don't want) and executing that in one shot to create the DB environment.
The problem we are running into is that Packager seems to be appending a special character at the end of the schema.sql file and when it gets appended to our master delta script file, it foils the execution of the first line of our data file. In this case: SET NUMERIC_ROUNDABORT OFF. We encounter a syntax error. If you set your cursor to the beginning of the line and hit backspace once, the SET command colors blue and everything works fine.
I have tried to determine what the character code number is, and it comes back as character code 63, which is really odd, because that is a question mark, and I obviously don't see it in the script before execution. I'm sure it has something to do with the Unicode encoding, but I haven't figured it yet. Regardles, the below code snippet is my copy command:
COPY /B /Y "$(REDGATE_COMPARE_OUT)\\Delta_Schema.sql" + "$(REDGATE_COMPARE_OUT)\\Delta_data.sql" "$(REDGATE_COMPARE_OUT)\\AllDeltas.sql"
and this snippet is the XML that I am using when I execute Packager via command line (I have removed the username/password info):
Has anyone else run into this? I really need this character to not be there and any help would be appreciated. Thanks.