User profile for Andrew P

Hey Kev, The devs have created bug number SC-9645 for that issue and are currently investigating. Do let us know if you have any additional questions in the meantime! Warmly, / comments

Hey Kev, The devs have created bug number SC-9645 for that issue and are currently investigating. Do let us know if you have any additional questions in the meantime! Warmly,

0 votes

Hey Ed, This was fixed in v12.2.2.4140 I recommend you upgrade to the latest Frequent Updates release and retest. Do let me know if you continue to have this issue afterwards! / comments

Hey Ed, This was fixed in v12.2.2.4140 I recommend you upgrade to the latest Frequent Updates release and retest. Do let me know if you continue to have this issue afterwards!

0 votes

Hey Noel, Thanks for contacting us! The automatic schema change patch file is the initial Compare block - see documentation https://documentation.red-gate.com/display/SOC5/How+migration+scripts+work When you go to deploy it, you can choose the "Ignore check constraints" or "Ignore WITH NOCHECK" comparison options if you are using SQL Compare or DLM Automation to deploy - documentation on that https://documentation.red-gate.com/display/SC12/Setting+project+options Do let me know if you have any issues with that! / comments

Hey Noel, Thanks for contacting us! The automatic schema change patch file is the initial Compare block - see documentation https://documentation.red-gate.com/display/SOC5/How+migration+scripts+wo...

0 votes

Hey Baidaly, Thanks for contacting us! I am not aware of the ability to do that within TeamCity - here is the documentation on Logging in TeamCity https://confluence.jetbrains.com/display/TCD10/Viewing+Build+Agent+Logs and there are not currently any options to change the logging color for our PowerShell output - but I think that would be a good suggestion for our UserVoice forum https://redgate.uservoice.com/forums/267000-dlm-automation I apologize for the inconvenience! Warm Regards, / comments

Hey Baidaly, Thanks for contacting us! I am not aware of the ability to do that within TeamCity - here is the documentation on Logging in TeamCity https://confluence.jetbrains.com/display/TCD10/Vie...

0 votes

Hey tsmith, Thanks for contacting us! You can set up a Filter to exclude them, or go to Comparison Options (both under the Setup tab) and uncheck the "Decrypt encrypted objects" option. https://documentation.red-gate.com/display/SOC5/Exclude+objects+using+filters and https://documentation.red-gate.com/display/SOC5/Change+the+comparison+options Let me know if you have any issues with that! Warmly / comments

Hey tsmith, Thanks for contacting us! You can set up a Filter to exclude them, or go to Comparison Options (both under the Setup tab) and uncheck the "Decrypt encrypted objects" option.https://docu...

0 votes

Thanks for contacting us! It might be better to use a Computed Column instead of SQL Data Generator- Data Generator cannot do single column generation - it does whole rows. https://msdn.microsoft.com/en-us/library/ms188300.aspx If you do want to generate new rows, or delete the current records and insert new ones, then you can concatenate like that using the "Simple expression generator" https://documentation.red-gate.com/display/SDG3/Generic+generators Do let me know if you have any questions or issues with that! Warm Regards, / comments

Thanks for contacting us! It might be better to use a Computed Column instead of SQL Data Generator- Data Generator cannot do single column generation - it does whole rows.https://msdn.microsoft.co...

0 votes

Hey Webrageous, Thanks for contacting us and sorry you are having this issue! It depends on how much data you are comparing/deploying - if you watch the amount of disk space it takes up you can see whether that is a limiting factor, or perhaps you are on an older version of SQL Data Compare that is not 64 bit (I recommend using the latest version- v12). Here is some more info on improving performance http://documentation.red-gate.com/display/SDC12/Getting+better+performance+out+of+SQL+Data+Compare Also if the script is large enough to have issues deploying with SQL Data Compare - you probably will not be able to deploy it using SSMS - it is still 32 bit so it cannot handle large scripts (most text editors cannot handle very large scripts actually). I hope that helps! Warm Regards, / comments

Hey Webrageous, Thanks for contacting us and sorry you are having this issue! It depends on how much data you are comparing/deploying - if you watch the amount of disk space it takes up you can see...

0 votes

Hey Alex, Thanks for contacting us! This looks to be a WCF error - when you say a build - is that a build using SQL Compare or DLM Automation? What build steps do you have - especially the step directly previous to this one? If you put in a manual intervention step prior to the SQL Doc run- does it run successfully after manually approving? Warmly, / comments

Hey Alex, Thanks for contacting us! This looks to be a WCF error - when you say a build - is that a build using SQL Compare or DLM Automation? What build steps do you have - especially the step dir...

0 votes

Hey Imran, Git is a distributed Version Control system - so usually it will not work well with a Shared model. Think about it this way if everyone has different local copies of the repository, but they are all working on the same database - which one is going to be correct, the database or the repository? The database would be always right - but the repositories will be in different states - so someone could make a change to the database, then someone else could make that change to their local repo - so the history now attributes the change to the incorrect user. If everyone was making changes and committing them to their local repositories, they would all have different git histories with duplicate entries with different revision numbers - so your remote git history would be really odd and incorrect making it less meaningful. If you are even thinking of using Migration Scripts - they will not even remotely work with this type of a setup because they rely on changes to the database and changes to the repository being directly related. Ordering becomes very important So you can hack around this fundamental issue by using the Git command line hooks (like you have done) - but they do not give you the option to push or pull - nor will you be able to view the Git history from SQL Server Management Studio. If you must use Git - then you should be using the Dedicated model. If you must use the Shared model - then you should be using a Centralized Versioning System such as Subversion or TFS. Do let me know if you have any questions or issues with this! Warmly, / comments

Hey Imran, Git is a distributed Version Control system - so usually it will not work well with a Shared model. Think about it this way if everyone has different local copies of the repository, but ...

0 votes

Hey Scott, Thanks for contacting us! What type of version control system are you using (Git, SVN, TFS)? What version of SQL Source Control are you using? Thanks! / comments

Hey Scott, Thanks for contacting us! What type of version control system are you using (Git, SVN, TFS)? What version of SQL Source Control are you using? Thanks!

0 votes

How can we help you today?

Andrew P

Comments