Comments
Sort by recent activity
Additional info:
I updated the database by running all the other part of the scriptfile. So now it's only FUNCTION1 and FUNCTION2 that differs. But I still get an illegal scriptfile.
It works fine if I change the name (DROP/CREATE) of FUNCTION2.
If I change it back it doesn't work [image]
I have tried several different names - and all (but the one I want) works fine???
PS. We have earlier had problems with illegal denpendencies in our scriptfiles generated by SqlCompare. It slows our update procedure down, when we have to modify the script manually each time. / comments
Additional info:
I updated the database by running all the other part of the scriptfile. So now it's only FUNCTION1 and FUNCTION2 that differs. But I still get an illegal scriptfile.
It works fine ...
Thanks.
I found a patch that fixed the problem: http://www.red-gate.com/messageboard/vi ... hp?t=11077
SC-4896 /ScriptFile:"<path\name.sql>" does not appear to generate script file (regression from 8.2) / comments
Thanks.
I found a patch that fixed the problem:http://www.red-gate.com/messageboard/vi ... hp?t=11077
SC-4896 /ScriptFile:"<path\name.sql>" does not appear to generate script file (regression from ...
I got the same problem as abaker97:
If I specify /scriptfile without /sync I don't get my scriptfile ex:
sqlcompare /s1:<server1> /db1:<db> /s2:<server2> /db2:<db> /scriptfile:c:\somefolder\somescript.sql
Including the /sync switch will generate the scriptfile ex:
sqlcompare /s1:<server1> /db1:<db> /s2:<server2> /db2:<db> /scriptfile:c:\somefolder\somescript.sql /sync
I'm using SqlCompare8! Is this a bug which has been fixed in SqlCompare9?
Is it because I'm comparing across servers? / comments
I got the same problem as abaker97:
If I specify /scriptfile without /sync I don't get my scriptfile ex:
sqlcompare /s1:<server1> /db1:<db> /s2:<server2> /db2:<db> /scriptfile:c:\somefolder\somescr...