Activity overview
Latest activity by janhansen
Hi Chris,
I'll prepare exactly the steps I go through in a word document and mail it to you, so you can reproduce.
Edit: Mail sent to you
Jan / comments
Hi Chris,
I'll prepare exactly the steps I go through in a word document and mail it to you, so you can reproduce.
Edit: Mail sent to you
Jan
Differential backups
I did this scenario to see how differential backup comparison is carried out:
1) Made a full database backup of a simple 1 table database
2) Added a couple of rows in the database
3) Made a comparison of the backup with the online database. All works well - the added rows are identified as being in the online database and not in the backup
4) Then I did a new backup of the database. This time only a differential backup. The differential backup is done to the same backupfile used in step 1.
5) Suddenly the comparison project can't/wont run any more. Even if I uncheck the "Always use latest backup" and select the backup set made in step 1 I get an error running the comparison. The error comes when Data Compare tries to register databases - and goes "index out of bounds".
I haven't bothered to check the documentation - this might very well not be a supported feature - in that case no problems - but if it is an intended feature I can make it work :?
regards
Jan / comments
Differential backups
I did this scenario to see how differential backup comparison is carried out:
1) Made a full database backup of a simple 1 table database
2) Added a couple of rows in the datab...
I think the text entered before the "same" is checked/unchecked on the right should be saved and redisplayed. It's easy to - accidentically - hit the check box by error and then having to re-enter the criteria from scratch.
regards
Jan / comments
I think the text entered before the "same" is checked/unchecked on the right should be saved and redisplayed. It's easy to - accidentically - hit the check box by error and then having to re-enter ...
Hi,
Thanks for your answer - I'm well aware of the behaviour and how to do, you explain. My point is only, that if you setup a right hand where clause, accidently check the "use same" and want to reset to the right hand where clause, the original entered where clause is gone - and you have to reenter it.
By the way - real nice with fast feedback on the issues.
greets
jan / comments
Hi,
Thanks for your answer - I'm well aware of the behaviour and how to do, you explain. My point is only, that if you setup a right hand where clause, accidently check the "use same" and want to r...
Where clause disappears
1) I enter the WHERE clause/Filter editor form
2) By default the "Use the same WHERE clause for both objects" are turned ON. I turn it OFF making it possible to specify a WHERE clause for the Source database (right hand WHERE clause text box)
3) I enter a where clause like "CustomerCountry = 'DK'" in the right hand WHERE clause text box.
4) I turn ON the "Use the same WHERE clause for both objects" and my WHERE clause entered in step 3 disappears. If I turn OFF the "Use the same WHERE clause for both objects" again, it would be nice if the clause entered in Step 3 reappeared - but it doesn't - it's gone with the wind!
I've tried to close the WHERE form after step 3, opening it and executing Step 4 - still my where clause doesn't reappear.
Jan / comments
Where clause disappears
1) I enter the WHERE clause/Filter editor form
2) By default the "Use the same WHERE clause for both objects" are turned ON. I turn it OFF making it possible to specify a WH...
Hi .. still looking into it. Found another tiny thing: Line breaks in "comments field" in "Comparison Projects" form
I can't insert a carriage return/line break in the "comments" field on the "Comparison Project" form. I've tried <Return> and <Ctrl><Return>, but both keystrokes closes the comment box.
Jan / comments
Hi .. still looking into it. Found another tiny thing:Line breaks in "comments field" in "Comparison Projects" form
I can't insert a carriage return/line break in the "comments" field on the "Compa...
Compare results of executing stored procedures and functions
Is there a way to compare the results of executing procedures and/or functions on 2 databases ? This would be very handy for me in the kind of customer setup's I'm working in on a daily basis.
Jan / comments
Compare results of executing stored procedures and functions
Is there a way to compare the results of executing procedures and/or functions on 2 databases ? This would be very handy for me in the k...
Hi Robert,
Thanks for you answers - haven't noted the WHERE clause option .. nice !!
Jan / comments
Hi Robert,
Thanks for you answers - haven't noted the WHERE clause option .. nice !!
Jan
Support for other input sources
It would be nice - in a comming version - to be able to select other input sources than Live og Backups of SQL Server databases. E.g. comparison of data between an MS Access database (or other odcb compliant databases) and a SQL Server database.
Any plans for this in the future ? / comments
Support for other input sources
It would be nice - in a comming version - to be able to select other input sources than Live og Backups of SQL Server databases. E.g. comparison of data between an M...
Dynamic compare using WHERE clause
Maybe I just haven't looked into Data Compare good enough, but I seem to lack the possibility to do compares based on a dynamic query - for example: I want to compare the results of running an ad-hoc select query (eg: "select customername from t_Customer where country = 'DK') in database 1 with the same ad-hoc select query in database 2 / comments
Dynamic compare using WHERE clause
Maybe I just haven't looked into Data Compare good enough, but I seem to lack the possibility to do compares based on a dynamic query - for example:I want to comp...