I have been using the sql compare utility and am close to the end of our trial period.
However it has now started failing with a "divide by zero" error which we cannot get past ... this is a bit of a bummer and there is no work around, other than to restore a newer database and start the comparisons from a new start point (not really an option as I remote work and I cant transfer a 20gb database over the net).
If there was some way of creating a more in-depth log for you to find out where it might be, I would be happy to do it ... but I cannot see you being able to find it without the databases for comparison (which isnt really viable) or checking every line of code.
Your help would be appreciated.
Divide by Zero Error
Re: Divide by Zero Error
Thanks for your post.
Please tell us the exaсt product (Schema Compare or Data Compare) and its version (see Help->About).
Please tell us the exaсt product (Schema Compare or Data Compare) and its version (see Help->About).
Don't worry. We can extend the trial period for you if it will be necessary. Just send us a mail when your trial period will be expired.coderanger wrote:I have been using the sql compare utility and am close to the end of our trial period.
Could you please send us an error report generated by our product (or the exact message of this error)?coderanger wrote: However it has now started failing with a "divide by zero" error which we cannot get past ... this is a bit of a bummer and there is no work around, other than to restore a newer database and start the comparisons from a new start point (not really an option as I remote work and I cant transfer a 20gb database over the net).
If there was some way of creating a more in-depth log for you to find out where it might be, I would be happy to do it ... but I cannot see you being able to find it without the databases for comparison (which isnt really viable) or checking every line of code.
Your help would be appreciated.
-
- Posts: 8
- Joined: Mon 27 Sep 2010 07:25
Devart dbForge Data Compare for SQL Server v2.0.158Please tell us the exaсt product (Schema Compare or Data Compare) and its version (see Help->About).
Trial version: 4 of 30 days left.
No error report, it just says "Divide by zero" ... here is the log...Could you please send us an error report generated by our product (or the exact message of this error)?
Code: Select all
==============================================================================
Devart dbForge Data Compare for SQL Server v2.0.158
Trial version: 4 of 30 days left.
===============================================================================
Started at: 19/10/2010 08:03:49.
Command line: /compfile:"\BOB\Tools\PDB-to-PDBCompare.dcomp" /sync:"Z:\PDB Data
base Deltas\DeltaFrom20100929 - 2010-10-19-0805.sql"
Connecting to ZEUS...OK
Connecting to ZEUS...OK
Source: Database
Server = ZEUS
Database = Programmes
Server version = 10.00.2531
Target: Database
Server = ZEUS
Database = ProgrammesCompare
Server version = 10.00.2531
Describing objects...OK
Mapping objects...OK
Comparing data...OK
Summary:
-------------------------------------------------------------------------------
== Identical 0
Different 18936
>> Only in Source 65273
x Conflict Source Records 0
x
1 >>
dbo.ChannelCountry 2 >>
dbo.ChannelProviders 6 >>
dbo.Person 2
58 >>
2 >
4
138 >>
dbo.PersonProgrammeTypeLink 963
268 >>
7
236 >>
15
23 >>
2
451 >>
24 >
dbo.ProgrammeKeyword 2
100 >>
6 >
dbo.ProgrammesHiddenFromReports 2 >>
dbo.Schedule 16834
63922 >>
1918 >
dbo.ScheduleUpdate 4 >>
-------------------------------------------------------------------------------
Identical records are excluded by option.
Synchronizing objects...
-------------------------------------------------------------------------------
-- Updating data of table dbo.Channel...OK
-- Inserting data into table dbo.Channel...OK
-- Inserting data into table dbo.ChannelCountry...OK
-- Inserting data into table dbo.ChannelProviders...OK
-- Deleting data from table dbo.Person...OK
-- Updating data of table dbo.Person...OK
-- Inserting data into table dbo.Person...OK
-- Deleting data from table dbo.PersonAlias...OK
-- Inserting data into table dbo.PersonAlias...OK
-- Deleting data from table dbo.PersonEpisodeTypeLink...OK
Attempted to divide by zero.
Synchronization failed.
Finished at: 19/10/2010 08:05:15.
Thank you for sending your application logs. They greatly helped us.coderanger wrote:Thanks, have replied
We found when the division error occurs and have already fixed it. We will make a build of our tool with the fix today, but will need some time to make regression tests on it. The build will be available for public use no sooner than this Thursday or Friday.
Sorry for any inconvenience you encountered while using our product.