Page 1 of 1
Can't do a Data Compare using backup files
Posted: Thu 12 Mar 2015 19:30
by nilknarf78
I'm trying to use Data Compare to compare backup files. However, when I select the backup files, they have a red circle with and 'x' and I can't set any options. When I try to select options or mapping in the New Comparison window, I just get a message saying to select a database to compare.
Any thoughts on this?
I'm running on SQL Server 2014 and there's nothing special about how I created the backups. And, according to the "Check for updates" function, I have the latest version of Data Compare.
Thanks in advance!
Re: Can't do a Data Compare using backup files
Posted: Fri 13 Mar 2015 12:52
by alexa
Could you please send us the backup files so we can reproduce the issue on our side?
You can send a reply straight to our support system at supportATdevartDOTcom
Re: Can't do a Data Compare using backup files
Posted: Thu 30 Apr 2015 18:13
by nilknarf78
Apologies for the delay in responding. I completely forgot about this until today when I went to try and do this again.
I've determined the issue is with compression. I can open a backup that wasn't created with compression. However, if I create a backup with compression turned on, Data Compare can not open it.
Re: Can't do a Data Compare using backup files
Posted: Fri 01 May 2015 07:11
by alexa
We are currently reviewing this post and will answer you as soon as possible.
Re: Can't do a Data Compare using backup files
Posted: Fri 01 May 2015 07:32
by alexa
Could you please let us know what product you were making the backup with and specify its version.
Please also send us a test backup file for investigation to supportATdevartDOTcom and alexaATdevartDOTcom
Re: Can't do a Data Compare using backup files
Posted: Mon 18 May 2015 17:52
by nilknarf78
The backup is being created with SQL Server 2014.
I'll see what I can do about sending you a sample file.
Thanks!
Re: Can't do a Data Compare using backup files
Posted: Tue 19 May 2015 14:56
by alexa
Thank you for the reply.
We will fix this issue in one of the next product builds and will notify you once it's available for downloading.
Re: Can't do a Data Compare using backup files
Posted: Sat 20 Jan 2018 08:42
by jacemdom
I am experiencing the same problem. I am using dbForge Pro 5.4.275 and SLQ Server Express 2017.
Any suggestions?
Re: Can't do a Data Compare using backup files
Posted: Sat 20 Jan 2018 14:07
by jacemdom
Just rolled back to SQL Server 2014 and it works...maybe just not compatible with 2017...
Re: Can't do a Data Compare using backup files
Posted: Wed 25 Aug 2021 14:10
by dsc
The Issue still exists in the current version dbforge Studio for SQL-Server Enterprise 6.0.470 when using a SQL-Server 2017 and a backup from this server version.
the topic is more than 3 years old. will there be a fix in a new version soon? Roleback to an older server is no option for me.
Re: Can't do a Data Compare using backup files
Posted: Thu 26 Aug 2021 09:23
by alexa
Currently, dbForge supports backups of the SQL servers lower than SQL Server 2014.
Though, we are planning to support backups of the higher versions in one of the next product versions.