Comments
Sort by recent activity
Hi there,
I have some good news for you - If I understand your request correctly I think that what you are asking for is already in the product.
To access this functionality what you need to do is to start a new project set up the servers and databases tab then click on the tables and views tab after the software has fetched the schema from the server you will be presented with a list of tables to compare against one another, the check box in the middle of this table allows you include/exclude the whole table from the comparison and syncrhonization process - however if you have a table included you can then click on the drop down in the right most column (Where it says "x columns") and select the individual columns to include in the comparison - thus excluding the columns you dont want to change.
Is this the functionality you were looking for? If not let me know and I will add a feature request for future versions of the product.
Hope this helps,
James
--
James Moore
Red Gate Software Ltd / comments
Hi there,
I have some good news for you - If I understand your request correctly I think that what you are asking for is already in the product.
To access this functionality what you need to do is ...
Hi Mark,
SQL Data Compare 4 uses your temp directory to store its working files so if you alter your TEMP environmental variable you can point SDC4 at another drive.
SQL Data Compare 5 (which is currently in public beta - see http://www.red-gate.com/messageboard/viewforum.php?f=35) has some extra support for this - in RC1 we support a environmental variable called RGTEMP which allows you to tell Data Compare where to store its working set however this does not currently change where synchronization SQL scripts etc are generated so there will still be some quite heavy usage of your temp folder. This issue with the location used for SQL Generation is fixed in the final release of Bundle 5 – due to be released in early April.
I hope this helps,
- James
--
James Moore
Red Gate Software / comments
Hi Mark,
SQL Data Compare 4 uses your temp directory to store its working files so if you alter your TEMP environmental variable you can point SDC4 at another drive.
SQL Data Compare 5 (which is cu...
Hi Peter,
Version 5 of SQL Data Compare supports custom comparison keys as you describe.
V5 is current in public beta and availible from (http://www.red-gate.com/messageboard/viewforum.php?f=35 - You might need to be registered and logged in to see the forum) If you could take a look at the new functionality and let me know if it does everything you need then that would be great.
Many thanks,
- James
--
James Moore
Red Gate Software / comments
Hi Peter,
Version 5 of SQL Data Compare supports custom comparison keys as you describe.
V5 is current in public beta and availible from (http://www.red-gate.com/messageboard/viewforum.php?f=35 - ...
Just a little update on this.
We renamed this variable between the Beta and RC1 from RGDCTEMP to RGTEMP. There is also a known issue in both the Beta and RC1 in that the Data Compare Engine stores all of its data files in this location however the generated script will still end up in your windows temp folder.
This issue will be fixed in the final release.
- James
--
James Moore
Red Gate Software Ltd / comments
Just a little update on this.
We renamed this variable between the Beta and RC1 from RGDCTEMP to RGTEMP. There is also a known issue in both the Beta and RC1 in that the Data Compare Engine stores ...
Hi Erik,
Thanks for retrying that.
We have now resolved the issue in our internal builds (It was related to our syntax highlighting with large objects which are different but exist in both databases).
We will post another RC in the next few days and if you could give it a try again with the next RC it would be very much appreciated.
Many thanks
- James
--
James Moore
Red Gate Software Ltd / comments
Hi Erik,
Thanks for retrying that.
We have now resolved the issue in our internal builds (It was related to our syntax highlighting with large objects which are different but exist in both databas...
Hi,
Thanks for the comments about the compairson reports, I have logged your request about including only the selected items in a comparison report and we will look at adding that functionality for the final release although I cant promise anything at this time.
Also on the MHT front we will certainly be looking to put this into the final release. As a temporary measure if you look in C:\Program Files\Red Gate\SQL Bundle 5 you will find a file called SQLCompareInteractiveReportTemplate.xsl on line 298 you will find the text: var imagesdir = "http://www.red-gate.com/scimages/";
Rather than pointing this to our site you can change this line to:
var imagesdir = "file://C:/Program Files/Red Gate/SQL Bundle 5/Reporting/images/"; At this point you no longer need to have an internet connection (Although you need to be on a machine with SQL Bundle 5 installed).
Hope this helps,
- James
--
James Moore
Red Gate Software Ltd / comments
Hi,
Thanks for the comments about the compairson reports, I have logged your request about including only the selected items in a comparison report and we will look at adding that functionality for...
Steve,
I went through most of the new features in Data Compare in my blog: http://blogs.red-gate.com/blogs/james/archive/2006/02/27/Data_Compare_5_Beta.aspx
Just a little information on Custom Comparison keys that you and perhaps others will find useful. In previous versions of Data Compare you needed to have an index/pk on a table to compare them, or a clustered index on a view.
The idea behind custom comparison keys is that you can now compare tables and views with no pk/index defined by telling data compare explicitly which column pair(s) to use when matching up records in the two databases you are comparing.
Custom Comparison keys do not alter your database but you should be careful which columns you pick (and in general they should be unique) as it will effect the comparison and the eventual sync script Data Compare generates.
If its still not clear then let me know or best of all give them a try...
- James
--
James Moore
Software Engineer
Red Gate Software Ltd / comments
Steve,
I went through most of the new features in Data Compare in my blog: http://blogs.red-gate.com/blogs/james/archive/2006/02/27/Data_Compare_5_Beta.aspx
Just a little information on Custom Comp...
Hi Andy,
We have changed the behaviour of that grid on our internal builds so this functionality will be available in the final release. You will be able to sort on the mapping column which will group mapped tables together and partially mapped tables together.
Unmapped tables will of course still appear in the lower grid.
Many thanks for the suggestion,
- James
--
James Moore
Software Developer
Red Gate Software Ltd / comments
Hi Andy,
We have changed the behaviour of that grid on our internal builds so this functionality will be available in the final release. You will be able to sort on the mapping column which will gr...
The clone option will be in the final release of Data Compare, unfortunately it didn’t quite make it into the beta.
You can always do it manually for now if you are setting up projects to use later - just copy the appropriate file under C:\Documents and Settings\<user name>\Local Settings\Application Data\Red Gate\SQL Data Compare 5 and restart Data Compare.
- James
--
James Moore
Software Engineer
Red Gate Software Ltd / comments
The clone option will be in the final release of Data Compare, unfortunately it didn’t quite make it into the beta.
You can always do it manually for now if you are setting up projects to use lat...
Hi Toby,
We don't impose a limit on the number of projects intentionally, could you do a couple of things for me please.
1. Send me a screen shot of the Comparison Projects screen where your projects are listed, my email address is james.moore@red-gate.com.
2. Check the number of files which exist in C:\Documents and Settings\<user name>\Local Settings\Application Data\Red Gate\SQL Compare 5
Many thanks for your help with this.
- James
--
James Moore
Software Engineer
Red Gate Software Ltd / comments
Hi Toby,
We don't impose a limit on the number of projects intentionally, could you do a couple of things for me please.
1. Send me a screen shot of the Comparison Projects screen where your projec...