How can we help you today? How can we help you today?
DanC
Hi BobbyOwens apologies you're experiencing this readability issue, seeing as this is a feature request may I ask that you post it here on the UserVoice for the development team to review.  / comments
Hi BobbyOwens apologies you're experiencing this readability issue, seeing as this is a feature request may I ask that you post it here on the UserVoice for the development team to review. 
0 votes
Hi @howarthcd this has now been fixed and pending release into the next frequent update. If you keep an eye out the next release suggested to you will contain the fix! / comments
Hi @howarthcd this has now been fixed and pending release into the next frequent update. If you keep an eye out the next release suggested to you will contain the fix!
0 votes
Hi @howarthcd I've managed to reproduce this, it still allows you to run the comparison in 14.2 although it shows an error. I've done a bug report for this and will keep you posted! Bug report reference SC-10773 / comments
Hi @howarthcd I've managed to reproduce this, it still allows you to run the comparison in 14.2 although it shows an error. I've done a bug report for this and will keep you posted! Bug report refe...
0 votes
Hi @rarifiedone so if I'm understanding your scenario correctly I have a few potential solutions for you! So first one would be using SQL Source Control (SOC) to create a scripts folder using SQL Compare Pro CMD using the switch /Include:StaticData. So the way this would work is to set SOC to a working folder and setup tables to have static data, then in the Compare commandline use the SOC working folder as the source to compare against "database b". The documentation here will take you through setting up different sources for comparison - https://documentation.red-gate.com/sc/setting-up-the-comparison/setting-data-sources.  Also the documentation here it will show an example of using the StaticData switch - https://documentation.red-gate.com/sc/using-the-command-line/switches-used-in-the-command-line This option would combine the functionality of both SQL Compare and Data Compare in one go.  Second option, you would do the process in two stages just using SQL Compare and Data Compare. Essentially you will first use SQL Compare to compare database A to database B and generate a deployment script to deploy the schema and objects into SQL Server (which the godlike sql admins will use). Second stage would once the deployments have occurred, you would then use Data Compare to compare A-B once again, then generate a deployment script for the data you wish to deploy.  Appreciate that's a slightly slower and time consuming process for what you're trying to achieve!  Hope this covers your query! / comments
Hi @rarifiedone so if I'm understanding your scenario correctly I have a few potential solutions for you!So first one would be using SQL Source Control (SOC) to create a scripts folder using SQL Co...
0 votes
Hi @Andy_H this has now been fixed and released in Prompt 10.1.0, so if you could please upgrade to the current latest! / comments
Hi @Andy_H this has now been fixed and released in Prompt 10.1.0, so if you could please upgrade to the current latest!
0 votes
Hi @Andy_H thank you for providing the level of detail here! made it very easy to determine this is an issue and witness it myself. I'm going to escalate this to the developers and I'll give you an update once I have some info!  / comments
Hi @Andy_H thank you for providing the level of detail here! made it very easy to determine this is an issue and witness it myself. I'm going to escalate this to the developers and I'll give you an...
0 votes