Comments
Sort by recent activity
I even updated the sql compare version to 14.1 from 13.8 and still getting the same error / comments
I even updated the sql compare version to 14.1 from 13.8 and still getting the same error
Thank you Tianjiao_Li for the response. / comments
Thank you Tianjiao_Li for the response.
Thanks Alex, I tried some scenarios and it came as exactly as you explained in the accepted answer. / comments
Thanks Alex, I tried some scenarios and it came as exactly as you explained in the accepted answer.
Thank you Alex, I will go through this link and try to solve it. / comments
Thank you Alex, I will go through this link and try to solve it.
I am using redgate source control via git and I am wondering if I can just deploy the object change without effecting the data in target server while syncing the database. For example, If a developer creates a table with data then I want to source control only table structure and sync it to the target database using dlm automation but I want to manully add data in the target database. I can do so for the first time but I have a doubt that if I will sync with the target database which already have some data then the sync process might delete all data in the target database. I would like to know if it is possible to use dlm automation to syn data structure only to target database without effecting the current data in the target database and add data to new structure separately in target database itself. Thank you Alex for the support. / comments
I am using redgate source control via git and I am wondering if I can just deploy the object change without effecting the data in target server while syncing the database. For example, If a develop...
Thank you for the response @Andrea_Angella but my situation is that I am using shared database with git and was wondering if anyone has done anything similar to this to create that push button and a branch name. It would make life of a developer so easy with those features. / comments
Thank you for the response @Andrea_Angella but my situation is that I am using shared database with git and was wondering if anyone has done anything similar to this to create that push button and ...
A database snapshot. Thank you for your response. / comments
A database snapshot. Thank you for your response.
thank you for the response / comments
thank you for the response
Thank you for the clarifications. Last but not least, for the main question , Does views get compiled at build/deploy? / comments
Thank you for the clarifications. Last but not least, for the main question , Does views get compiled at build/deploy?
Thank you Alex for the response, it clears up the confusion little bit. So does that mean views dependency issues are all covered by building only and if so how can I build views whose scripts has database name reference. They fails in build. Is there any tweak I can do anywhere so that DLM does not see them as an invalid objects. For example if I have a view script CREATE VIEW sample1 AS SELECT * FROM databasename.schemaname.tablename; Then I am getting build error: WARNING: The error 'Invalid object name databasename.schemaname.tablename;' occurred when executing the following SQL: and if I remove the databasename from the above script then it works. Please suggest me some idea as we have more than 500 views script with similar problem. Thank you for your response again. / comments
Thank you Alex for the response, it clears up the confusion little bit. So does that mean views dependency issues are all covered by building only and if so how can I build views whose scripts has ...