Activity overview
Latest activity by deeps
Thanks for the reply. I am using SQL Compare version 13.3.2. Rebuilt of table does not occur if the difference is only with the TEXTIMAGE_ON filegroup property. If there is any other difference in the table along with the TEXTIMAGE_ON filegroup property rebuilt occurs. / comments
Thanks for the reply. I am using SQL Compare version 13.3.2. Rebuilt of table does not occur if the difference is only with the TEXTIMAGE_ON filegroup property. If there is any other difference in ...
How to avoid table rebuilt when it occurs due to the difference in TEXTIMAGE_ON filegroup property
When deploying database with SQL compare and SQL change Automation, the table is rebuilt if there is a difference in TEXTIMAGE_ON filegroup property between source and target database. Tried with ...
Most of the time is taken in the build step, where a temporary database is build from scratch.It takes around 20-25 minutes. / comments
Most of the time is taken in the build step, where a temporary database is build from scratch.It takes around 20-25 minutes.
It takes about 40 minutes to complete the build. / comments
It takes about 40 minutes to complete the build.
Time taken for database deployment using Teamcity and Redgate tools
I use teamcity for CI process of database with the help of Redgate DLM automation build and Redgate DLM automation Sync step. It is taking about minutes to complete the 2 steps. Is there any method...
Thank You for the reply. I Insert records to a lookup/reference table in the source controlled Database. We have source controlled only schema not the data. In order to commit a row in a lookup table which method I should follow?
At a time mostly one entry is made to a table(Insert records also depend on data in other tables like the created by column from the users table). We have been using Migration Script feature for this. But while deployment using team city in the Build step we face many issues because there are no data in dependent tables. If we use Static Data concept the values in some columns are not same in Dev and Production environment. Please help me to resolve this. Thanks in Advance. / comments
Thank You for the reply. I Insert records to a lookup/reference table in the source controlled Database. We have source controlled only schema not the data. In order to commit a row in a lookup tab...
How to commit, deploy and take latest change for master table values with redgate and teamcity.?
Hi I am trying to automate the DB deployment process. As I am a beginner I have many doubts and confusions.
In case to insert or update a row to a master table (not frequently) should I use migrati...
Thank you for the answer. Can we use SQL local DB as the temporary database server in that case? / comments
Thank you for the answer. Can we use SQL local DB as the temporary database server in that case?
How to automate the deployment of migration script in Teamcity using DLM Automation process?
I have a source controlled DB with no data. While executing Migration scripts during build process causes error and it is failed. So we manually execute all migration scripts in DB. Help me to auto...
How can I deploy cross database dependent objects using DLM automation with Teamcity?
I have a database with cross dependent objects(objects on different DB, but on same server). While deploying with Teamcity using Redgate DLM Automation Build as Runner type and Temporary database s...