Comments
Sort by recent activity
Hi Eddie,
It does produce comparing results or create scripts folder when database is available. Generally it shows OK response back from command line if scripts generated correctly.
What if there is something going on at database side like database is not available because of restoring or something like network hiccup or database issue. SqlCompare should produce Error with cause. Sql compare 8 used to produce errors if it fails, but Sql compare 10 doesn't produce any errors even though database is not available.
What I am expecting here is some kind of Errors as and when Sql scripts doesn't generate script folder. What I have noticed, it doesn't generate scripts folders and responded as OK instead of Error from command line.
some of the errors shown below with Sql Compare 8 Unexpected error: Specified cast is not valid. Error: Error occurred connecting to database: Unexpected error: Object reference not set to an instance of an object.
Object reference not set to an instance of an object.System.NullReferenceException
at o.u()
at o.a(n )
at RedGate.SQLCompare.Engine.Database.Register(ConnectionProperties connectionProperties, Options options)
at o.a(LiveDatabaseSource )
at o.a(Int32 )
at o.a(String )
at RedGate.SQLCompare.CommandLine.CommandProcessor.b()
at RedGate.SQLCompare.CommandLine.CommandProcessor.Run()
at RedGate.SQLCompare.CommandLine.Startup.a(String[] )
I hope, It explains.
Thanks,
Saurin / comments
Hi Eddie,
It does produce comparing results or create scripts folder when database is available. Generally it shows OK response back from command line if scripts generated correctly.
What if there ...
Anybody can help on this?
Thanks much in advance.
-Saurin / comments
Anybody can help on this?
Thanks much in advance.
-Saurin
Saurin wrote:
I have been using SQL Compare 10 recently upgraded from 8 to 10 version and I have found that 10 doesn't produce any errors.
Does anybody has same issue like me? Sql Compare 8 was producing errors each time unlike Sql Compare 10.
Further, I am using Command as shown below.
"d:\Program Files (x86)\Red Gate\SQL Compare 10\SQLCompare.exe" /server1:tcp:ServerName /database1:Database1 /makescripts:d:\Temp\Database1 /options:CaseSensitiveObjectDefinition /force
Please somebody helps. Thanks in advance. / comments
Saurin wrote:
I have been using SQL Compare 10 recently upgraded from 8 to 10 version and I have found that 10 doesn't produce any errors.
Does anybody has same issue like me? Sql Compare 8 was ...