Activity overview
Latest activity by virtking
Hello,
Two points.
1. I just checked v7 of the tool and I don't see any option to force the syntax. Am I just not looking at the right place?
2. I've just created a data compare script with "left" db being an SQL 2000 and "right" db being an SQL 2005. The DROP INDEX syntax was generated with 2005 syntax. I used v7 of the SQL Data Compare. So in case SQL Compare is "cured", data compare is not.
Thanks. / comments
Hello,
Two points.
1. I just checked v7 of the tool and I don't see any option to force the syntax. Am I just not looking at the right place?
2. I've just created a data compare script with "left"...
Unhandled exception
I got the following exception using the released version:
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at _7._1(...
The way I got it to happen was that I generated script for just SPs and ran it in Query Analyzer (SQL2K). Once it ran I pressed the 'Refresh Comparison' button. Once that was done, I pressed 'Ok' on the popup window and that's when I got the Unhandled Exception. If I kept the app. open and hit the 'Refresh ...' button again, the same exception would happen again (I compared the error text). Since then I closed and reopened the app., did the same refresh and it worked just fine.
Unfortunately, I can't run it against any other database, since I only had one database for which I needed to run the generated conversion script. / comments
The way I got it to happen was that I generated script for just SPs and ran it in Query Analyzer (SQL2K). Once it ran I pressed the 'Refresh Comparison' button. Once that was done, I pressed 'Ok' ...
Unhandled exception
I know you don't want to get this type of errors at this point, but after performing a refresh in SQL Compare RC1 after SPs update, I'm constantly getting an unhandled exception. Here are the detai...
Hello Andras,
Thanks for your answers. I just have few comments on points 1 and 6.
1. I understand that support for SQL2005 server has complicated the logic. We use just SQL200 server and under v.3 of the tool the difference was identified. So my question is if it's known that both databases are on SQL2000 server(s), is it possible to just use v.3 logic?
6. Could you explain in more details, please, how mappings can be used to help with prefixing even if it's not complete?
I hope to get some comments on other points as well, possibly from other people [image]
Thanks. / comments
Hello Andras,
Thanks for your answers. I just have few comments on points 1 and 6.
1. I understand that support for SQL2005 server has complicated the logic. We use just SQL200 server and under v....
My comments/suggestions after some use of the Beta1
SQL Compare
1. I ran across a table which was marked as "=", but there was a difference in one of the constraints. I don't have a screen shot of it.
2. We keep objects under custom owners, so any...