Comments
Sort by recent activity
Excellent! I did hunt around the 'Tables & Views' tab, but missed the 'Columns in Comparison' grid column. Now it's obvious...
Thanks
Crispin / comments
Excellent! I did hunt around the 'Tables & Views' tab, but missed the 'Columns in Comparison' grid column. Now it's obvious...
Thanks
Crispin
I've worked it out. I hadn't applied the correct user permissions to the particular database, so I was being locked out. The 'network error' was a red herring. / comments
I've worked it out. I hadn't applied the correct user permissions to the particular database, so I was being locked out. The 'network error' was a red herring.
Hi Robert
Sorry for the delay. Here's the exception detail.
System.InvalidCastException was unhandled
Message="Specified cast is not valid."
Source="System.Windows.Forms"
StackTrace:
Server stack trace:
at L.a()
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
Exception rethrown at [0]:
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at System.Windows.Forms.Control.Invoke(Delegate method)
at N.a(IAsyncResult )
at System.Runtime.Remoting.Messaging.AsyncResult.SyncProcessMessage(IMessage msg)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
at System.Runtime.Remoting.Proxies.AgileAsyncWorkerItem.ThreadPoolCallBack(Object o)
at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)
Hope this helps. I need to be able to run a sync soon - will you be issuing a hotfix or something?
Regards
Crispin / comments
Hi Robert
Sorry for the delay. Here's the exception detail.
System.InvalidCastException was unhandled
Message="Specified cast is not valid."
Source="System.Windows.Forms"
StackTrace:
Server stack t...
Robert
I hate to say it but things seem to have got worse with 6.1. The crash problem I was experiencing involved SQL Server 2000 databases, but now I'm having a general problem (ie including SQL Server 2005 developer and Express editions) with SQL Data Compare 6.1. To see if it was my PC causing the problem I installed SQL Data Compare 6.0, then 6.1 on a reasonably clean Virtual Machine as well and ran into the same problem.
I've also tried to revert to 6.0 but that no longer works properly either.
Any ideas for a fix? It's suddenly got a bit critical as I now rely on being able to compare DBs.
Regards
Crispin / comments
Robert
I hate to say it but things seem to have got worse with 6.1. The crash problem I was experiencing involved SQL Server 2000 databases, but now I'm having a general problem (ie including SQL ...
Hi Robert
Thanks for the response. I had a go with the workaround but it didn't work for me. The default instance on th target machine is SQL Server 2005 developer edition and there is also an instance of SQL Server 2005 Express. In the past there were SQL Server 2000 instances but these have gone now.
I tried adding the value in the appropriate location with and without a trailing backslash just in case that made a difference - it didn't. I also added this value to both apparent instances of SQL Server.
The exported values are:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer]
"BackupDirectory"="D:\\SQL Server data\\2005 instance - Developer\\Backups\\"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer]
"BackupDirectory"="D:\\SQL Server data\\2005 instance - Developer\\"
Crispin / comments
Hi Robert
Thanks for the response. I had a go with the workaround but it didn't work for me. The default instance on th target machine is SQL Server 2005 developer edition and there is also an in...
Robert
I've thought of a more complex comparison that might be useful (well to me anyway). The ability to ignore carriage returns and linefeeds within the left or right panel (as appropriate) when making the comparison.
This means that if I've got a left-hand panel with linebreaks and a right-hand one without, I can still make a sensible comparison. To finish it off, the aforementioned word-wrap on both sides would make the comparison easier.
Crispin / comments
Robert
I've thought of a more complex comparison that might be useful (well to me anyway). The ability to ignore carriage returns and linefeeds within the left or right panel (as appropriate) when...
Richard
Thanks for your reply. I used to be on the beta programme and I'm quite happy to go on it again.
Crispin / comments
Richard
Thanks for your reply. I used to be on the beta programme and I'm quite happy to go on it again.
Crispin
David
Thanks. I'll leave it case sensitive.
One small point. On the Project Configuration 'Options' tab there's a couple of tick boxes for Mapping Behaviour marked "Ignore case" and "Ignore spaces", etc. The unwary might think that this refers to content rather than the object name. There is plenty of space to put in 'Ignore case in column name'. Ditto the others.
Crispin / comments
David
Thanks. I'll leave it case sensitive.
One small point. On the Project Configuration 'Options' tab there's a couple of tick boxes for Mapping Behaviour marked "Ignore case" and "Ignore space...
David
Thanks for your reply. I did that and it worked just fine.
I fall into the category of 'reluctant DBA' because I need to know about SQL Server for by web/software development activities. Collation has passed me by thus far - is there any reason why I shouldn't leave the column with a case-sensitive collation rather than reverting it?
Thanks
Crispin / comments
David
Thanks for your reply. I did that and it worked just fine.
I fall into the category of 'reluctant DBA' because I need to know about SQL Server for by web/software development activities. Co...
I agree with the comment about the Beyond Compare interface - it's brilliant.
Crispin / comments
I agree with the comment about the Beyond Compare interface - it's brilliant.
Crispin