Comments
Sort by recent activity
What "non manual" filters would you like? Apologies for the delay. Holidays got in the way. / comments
What "non manual" filters would you like? Apologies for the delay. Holidays got in the way.
Ah, that makes sense. We use the same filters everywhere, and tend to just expect people to build one in Compare. Not sure we'd add a web based one, but being able to click on a "type" of object and add a filter quickly would be nice. Not sure I could get a developer to add this, but I'll ask. / comments
Ah, that makes sense. We use the same filters everywhere, and tend to just expect people to build one in Compare. Not sure we'd add a web based one, but being able to click on a "type" of object an...
Is it just reviewing the changes for one of the databases? Do other dbs/instances work fine? / comments
Is it just reviewing the changes for one of the databases? Do other dbs/instances work fine?
Can I ask why you couldn't want a Get Latest or Commit refresh? The point of those is to compare (using the SQL Compare engine) what's in your db v the vcs. / comments
Can I ask why you couldn't want a Get Latest or Commit refresh? The point of those is to compare (using the SQL Compare engine) what's in your db v the vcs.
We have end of life'd the Comparison SDK. There was an announcement in the old forums: https://forum.red-gate.com/discussion/81556/retirement-of-sql-comparison-sdk#latest
The DLM tools supersede this. / comments
We have end of life'd the Comparison SDK. There was an announcement in the old forums: https://forum.red-gate.com/discussion/81556/retirement-of-sql-comparison-sdk#latest
The DLM tools supersede this.
For now there isn't anything here. You can copy each message, but only one at a time. I've sent a note to see if there is anything else that can be done or if a developer might add something. / comments
For now there isn't anything here. You can copy each message, but only one at a time. I've sent a note to see if there is anything else that can be done or if a developer might add something.
There isn't a facility to do this right now. You can export the diagram as XML and search in there. / comments
There isn't a facility to do this right now. You can export the diagram as XML and search in there.
You are welcome / comments
You are welcome
Refresh the schema in data generator. If you've saved the changes, not just made in the diagram, it should pick those up. / comments
Refresh the schema in data generator. If you've saved the changes, not just made in the diagram, it should pick those up.
You don't have correct DRI. If you want to constrain the data in Affiliate, your Municipio should have a PK on both IDDepartmento and IDMuicipo. You are asking them to both be a FK, but you haven't declared that. There's no definition of that relationship in your diagram.
You should have: create table Municipio
( id_municipio int not null
, id_departmento not null
, nombre_municipio varchar(200)
, constraint MunicipioPK primary keyt (id_departmento, id_municipio)
)
Then a FK declared as alter table Affiliate add constraint Affiliate_Municipio_FK Foreign Key (id_departmento, id_municipio) references Municipio (id_departmento, id_municipio)
/ comments
You don't have correct DRI. If you want to constrain the data in Affiliate, your Municipio should have a PK on both IDDepartmento and IDMuicipo. You are asking them to both be a FK, but you haven't...