Comments
Sort by recent activity
Hi mbass,
Our developers have confirmed that converting the time to UTC is the intended behavior at the moment. I'm sorry to say that there aren't any plans currently to add a feature to disable this, but they have asked if you can please put a feature request for it on our Uservoice forum Here
Our product managers use that forum as an important resource when considering new features and it allows other users to vote on the feature as well, to help add priority. They'll then post any updates to the request there. Kind regards, / comments
Hi mbass,
Our developers have confirmed that converting the time to UTC is the intended behavior at the moment. I'm sorry to say that there aren't any plans currently to add a feature to disable th...
Hi mbass, Are you referring to the Encapsulate as new stored procedure function? Best regards, / comments
Hi mbass,Are you referring to the Encapsulate as new stored procedure function?Best regards,
Hi, I believe this error was caused by the built in IntelliSense that comes with SSMS. I was able to recreate this issue in a Stored Proc without SQL Prompt installed. Please see below: [image] I hope this helps. Please let me know if you have any questions on this. Thanks, / comments
Hi,I believe this error was caused by the built in IntelliSense that comes with SSMS. I was able to recreate this issue in a Stored Proc without SQL Prompt installed. Please see below:I hope this h...
Hello Ikka, Yes, the issue of Datetime formatting was addressed in version 12.3.0.4373. In the release notes it lists:
SDC-2485: DateTime data is now formatted consistently in the differences grid.
Here is a link to the Release Notes (bottom of the page).
If your SQL Data Compare license for version 12.2 is still supported, than you should be able to upgrade to version 12.3. Please let me know if you have any other questions on this. Thanks / comments
Hello Ikka,Yes, the issue of Datetime formatting was addressed in version 12.3.0.4373.In the release notes it lists:
SDC-2485: DateTime data is now formatted consistently in the differences grid.
H...
Hi Doug, The sql backup jobs are ran as the account used for the SQL Backup Agent service. You can change the account used as well as the authentication mode for this service. To change the account used for this service:
From the Windows Control Panel, select Administrative
Tools > Services, or run services.msc.
Select the SQL Backup Agent service for the SQL Server
instance: SQL Backup Agent - <instance name>. Note: The SQL Backup Agent service for the local instance is
called just SQL Backup Agent.
Right-click the service and select Properties.
On the Log On tab, specify the account
you want the service to log on as. The account must have the permissions
listed above.
Click OK to close.
Right-click the service and select Restart to
restart the service and apply your changes.
note: You will need to restart the SQL Backup Agent service for the change to take effect. The rest of the documentation on SQL Backup permissions can be found here I hope this helps / comments
Hi Doug,The sql backup jobs are ran as the account used for the SQL Backup Agent service.You can change the account used as well as the authentication mode for this service.To change the account us...
Hi @PeterDaniels , Since you are targeting multiple servers to update, we would recommend using Package deployment scripts. Here is a link to the documentation page:
https://documentation.red-gate.com/sca3/developing-databases-using-sql-change-automation/generating-deployment-scripts/deployment-scripts I hope this helps. Best regards, Mac Frierson / comments
Hi @PeterDaniels ,Since you are targeting multiple servers to update, we would recommend using Package deployment scripts. Here is a link to the documentation page:
https://documentation.red-gate.c...
Hi @PeterDaniels , Since you are targeting multiple servers to update, we would recommend using Package deployment scripts. Here is a link to the documentation page:
https://documentation.red-gate.com/sca3/developing-databases-using-sql-change-automation/generating-deployment-scripts/deployment-scripts I hope this helps. Best regards, Mac Frierson / comments
Hi @PeterDaniels ,Since you are targeting multiple servers to update, we would recommend using Package deployment scripts. Here is a link to the documentation page:
https://documentation.red-gate.c...
Hi Peter, Since you are targeting multiple servers to update, we would recommend using Package deployment scripts. Here is a link to the documentation page:
https://documentation.red-gate.com/sca3/developing-databases-using-sql-change-automation/generating-deployment-scripts/deployment-scripts I hope this helps. Best regards, Mac Frierson / comments
Hi Peter,Since you are targeting multiple servers to update, we would recommend using Package deployment scripts. Here is a link to the documentation page:
https://documentation.red-gate.com/sca3/d...
Hello @gmcquibben
Unfortunately: "If running a Windows cluster, every node participating in the cluster requires a license. This includes passive nodes: these are automatically detected, and it is not possible to monitor only part of a cluster." You can find this information in our documentation for SQL Montior here: https://documentation.red-gate.com/sm9/getting-started/licensing / comments
Hello @gmcquibben
Unfortunately:"If running a Windows cluster, every node participating in the cluster requires a license. This includes passive nodes: these are automatically detected, and it is ...
Hi John, Have you tried our Redgate University site yet? It has a lot of great videos that give instruction on Redgate products. This particular series of videos really helped me understand and setup an automation CI on my own Azure DevOps using local DB's instead of the cloud. https://www.red-gate.com/hub/university/sql-change-automation-with-sql-source-control-projects Also, here are a couple of other articles that I think may help you. https://www.red-gate.com/hub/product-learning/?topic=continuous-integration Regards, Mac / comments
Hi John,Have you tried our Redgate University site yet? It has a lot of great videos that give instruction on Redgate products. This particular series of videos really helped me understand and setu...