User profile for Andrew P

Just to recap for anyone reading this - we fixed this by going to Owner Mapping and mapping the schemas together, then going to table mapping and mapping the tables together. Best, / comments

Just to recap for anyone reading this - we fixed this by going to Owner Mapping and mapping the schemas together, then going to table mapping and mapping the tables together. Best,

0 votes

Hey PDinCA, Thanks for contacting us and sorry you are having this issue! SQL Compare is a 64 bit program, but it potentially had some issues reading such a large backup. How much free space did you have on your local machine when you ran this? Did you notice a memory/HD usage spike during use? Would you mind enabling logging and sending in the log file? https://documentation.red-gate.com/disp ... +log+files Thanks! / comments

Hey PDinCA, Thanks for contacting us and sorry you are having this issue! SQL Compare is a 64 bit program, but it potentially had some issues reading such a large backup. How much free space did yo...

0 votes

Hey charmon, Thanks for contacting us! I've reached out via email to get more info on this - I'm thinking this has to do with collations but I look forward to digging deeper. Best, / comments

Hey charmon, Thanks for contacting us! I've reached out via email to get more info on this - I'm thinking this has to do with collations but I look forward to digging deeper. Best,

0 votes

Hey Mesosoup, Thanks for contacting us! I assume you are using the Static Data feature in SQL Source Control - the data scripts in Source Control always use Insert statements regardless of the change type - similarly the schema scripts only use Create scripts regardless of the schema change. This is because these scripts form a file-folder version of the database - SQL Compare and Data Compare will actually do the comparison between the scripts folder and the target database (they are at the heart of our DLM offering), and generate deployment scripts that will work well in the target database (eg Alters, Updates, etc). If you use SQL Data Compare to compare the Source Control scripts folder to the database you wish to deploy those changes to, do you see it doing a delete/insert or does it do updates? Kind Regards, / comments

Hey Mesosoup, Thanks for contacting us! I assume you are using the Static Data feature in SQL Source Control - the data scripts in Source Control always use Insert statements regardless of the chan...

0 votes

Hey Aj, Thanks for contacting us! You can nest folders, however it will still pick those objects up, and there is an easier way to do this. I recommend that you initially Commit those object to the source controlled repository, then use a Filter to exclude those objects from future commits. More info https://documentation.red-gate.com/disp ... ng+filters If you are using DLM Automation for your pipeline, it automatically picks up that filter and applies it when building/synching/testing/deploying. Do let me know if you have any issues with that! / comments

Hey Aj, Thanks for contacting us! You can nest folders, however it will still pick those objects up, and there is an easier way to do this. I recommend that you initially Commit those object to the...

0 votes

Hey Scoobs, It was good talking with you! Just to confirm, it does not support CDC objects and we were able to successfully build by disabling CDC on the build server, and filtering out the CDC objects. Those objects were more important for the prod environment, so I am glad that this was an acceptable workaround. Do contact us again if you encounter any other issues! Best, / comments

Hey Scoobs, It was good talking with you! Just to confirm, it does not support CDC objects and we were able to successfully build by disabling CDC on the build server, and filtering out the CDC obj...

0 votes

Hey egrant, I've been talking to the devs, and apparently this is a known issue with TeamCity plugin 4.0.1.70. They are working on it and I will let you know when it is finished. Best, / comments

Hey egrant, I've been talking to the devs, and apparently this is a known issue with TeamCity plugin 4.0.1.70. They are working on it and I will let you know when it is finished. Best,

0 votes

Thanks for the update Tom, If you scale down to 100% what is the result? / comments

Thanks for the update Tom, If you scale down to 100% what is the result?

0 votes

Hey Jculp, Thanks for contacting us! First I would recommend updating to the latest version of Compare. If that does not work, would you mind sending in a screenshot of the error? Thanks! / comments

Hey Jculp, Thanks for contacting us! First I would recommend updating to the latest version of Compare. If that does not work, would you mind sending in a screenshot of the error? Thanks!

0 votes

Thanks for contacting us and I apologize for the late reply! Currently, that is not available but I recommend you suggest that on our Uservoice site here https://redgate.uservoice.com/forums/94413-sql-prompt Warm Regards, / comments

Thanks for contacting us and I apologize for the late reply! Currently, that is not available but I recommend you suggest that on our Uservoice site here https://redgate.uservoice.com/forums/94413-...

0 votes

How can we help you today?

Andrew P

Comments