Activity overview
Latest activity by bjarni
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 ...
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 ...
synchronize script can't handle function dependencies
The synchronize script made by SqlCompare8 has (among alot of other things) two table-valued function:
CREATE dbo.FUNCTION1()
RETURNS TABLE
AS
RETURN (
SELECT ... FROM dbo.FUNCTION2()
INNER JOIN .....
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...