Activity overview
Latest activity by yzguy
let me see if I can simplify this. We start by running this statement on our db (drop the table, nothing existing): CREATE TABLE BATCH ( batch_id NUMBER GENERATED BY DEFAULT AS IDENTITY, coor_id VARCHAR2(50 BYTE) NOT NULL, stts VARCHAR2(30 BYTE), batch_dt DATE, crt_nm VARCHAR2(256 BYTE) DEFAULT USER, crt_dtm TIMESTAMP DEFAULT SYSTIMESTAMP, last_udt_usr_nm VARCHAR2(256 BYTE) DEFAULT USER, last_udt_dtm TIMESTAMP DEFAULT SYSTIMESTAMP ); then we SAVE that script in a script location, then use schema compare to compare the script location to our db, and it "sees" a difference between the script location and the db table (even though there is not any). Schema compare thinks it needs to make the db table an identity, when in fact it ALREADY is. The problem here is schema compares ability to determine that the column is an identity is not working, on this db. This works fine on another db, and I suspect will work fine for you. I suspect there is something wrong with one of our db's (or rights missing, or something different) as this works fine on another. My problem is that I don't know what schema compare is looking at, so I don't know where to start looking for problems. / comments
let me see if I can simplify this. We start by running this statement on our db (drop the table, nothing existing):CREATE TABLE BATCH ( batch_id NUMBER GENERATED BY DEFAULT AS IDENTITY, coor_id ...
Not exactly, you did reproduce something similar, but not what we did. You created a sequence and set it as a default value for a column, that is NOT what we did. We created a table with an identity column, and the SYSTEM created the sequence. This is NOT our issue. Our issue is trying to resolve why schema compare is not properly identifying an identity column in our db, as an identity. It tries to MAKE it an identity on EVERY release, even though there should be no change. There is likely a db issue, or oracle issue, but something is preventing schema compare from properly identifying this column as an identity in the db, so it repeatedly tries to make it an identity, every single time. / comments
Not exactly, you did reproduce something similar, but not what we did. You created a sequence and set it as a default value for a column, that is NOT what we did.We created a table with an identity...
Not exactly. The table was NEVER created with a default value and was ALWAYS an identity. We can recreate this on one db we have with a new table. We create the table, with identity, then use that script in a schema folder to generate an update script (which should do nothing) and it generates the script it thinks it needs, which is to change it TO an identity, but it already WAS an identity, it always was. The issue here is that schema compare is not detecting the column correctly when reading from the db. The issue is only reproduce able on one server that we have tried, it works fine on another. There is something different on the one server, but I have no idea what, or what to even look for. That is why I asked what specifically is schema compare looking for to detect if something is an identity column. It would give me a place to start looking. / comments
Not exactly. The table was NEVER created with a default value and was ALWAYS an identity. We can recreate this on one db we have with a new table. We create the table, with identity, then use th...
initial value reset when modifying tables with identity columns?
if you have a table with an identity column, and have data in it, then later need to modify that table, the script created to deploy the table, creates a new one, inserts the correct records, with ...
in case anyone else needs to know, this statement needs to return 1 for the user trying to commit changes
SELECT HAS_PERMS_BY_NAME('YourDBName', 'DATABASE', 'ALTER') / comments
in case anyone else needs to know, this statement needs to return 1 for the user trying to commit changes
SELECT HAS_PERMS_BY_NAME('YourDBName', 'DATABASE', 'ALTER')
I have been using sql compare for quite some time, and can use that just fine. There seems to be some rights issue I'm having, but I'm not sure exactly what sql source control is doing so I'm not sure what rights to ask for. For that matter, I'm not even 100% sure it is db rights, it could be TFS rights, but judging by the list of things it says it is doing, it looks to be all db related stuff until the end (and this is the very first thing it is trying to do).
I can probably get the rights, I just don't know what to ask for.
BTW, the compare and the list of items to check in works fine (which is what I would suspect to be similar to sql compare) it isthe commit changes that is failing. / comments
I have been using sql compare for quite some time, and can use that just fine. There seems to be some rights issue I'm having, but I'm not sure exactly what sql source control is doing so I'm not ...
What db rights are needed?
I recently installed SQL source control, and it looks like it will do exactly what we need. But so far I have run into a snag trying to check in changes.
We work with a shared dev db (multiple dev...