Activity overview
Latest activity by denisgil
Hi,
I never received an answer with the previous post. Would you please do a follow-up or the issue. The most important point is about a fix in order to work with user defined in any use case of comparaison.
I dont want also to 'scrap' my installation, unless you are saying that I can install an early access version safely (implies that I cas removed it too) / comments
Hi,
I never received an answer with the previous post. Would you please do a follow-up or the issue. The most important point is about a fix in order to work with user defined in any use case of co...
I will try it in TFS but if I am comparing two database, no matter what method I am using, I expect the same result. We are also building our database change script from the command line (in a .cmd script) in order to automate the generation from a case tool to the final script.
I don't understand what is the differences by reading all objects from source control or by reading it in a source or a destination database.
If there are differences, is there a fix that is comming ? The link you provide talk about an early access version, when this version will be availaible and what are the fix include within it ?
Lastly, is there any concern about the early access version for our licences ? Can I install and remove it in a friendly way ? / comments
I will try it in TFS but if I am comparing two database, no matter what method I am using, I expect the same result. We are also building our database change script from the command line (in a .cmd...
I am not afraid about losing data... I am afraid of processing time for large table. It's fine for one table, I can do it myself this time. Eventually I might have more table to do.
I suggest to have you developers verify more largely the support of user defined type. We are using this feature in a case tool to ease development and to have standards definition across the model (for example: ForeignKey, Amount, Date format (sql 2008), binary masks and so on... / comments
I am not afraid about losing data... I am afraid of processing time for large table. It's fine for one table, I can do it myself this time. Eventually I might have more table to do.
I suggest to ha...
Hi,
I have the lattest release of Sql Compare 9.0.0.79 Professional Edition and no update are available. This is the only change I made to the table and the article detailed do not apply.
The only thing that may differ here, is that we are using user defined type.
So we have the following definition:
if exists(select 1 from systypes where name='Identifier')
drop type Identifier
go
create type Identifier
from int
go
if exists(select 1 from systypes where name='Identifier64')
drop type Identifier64
go
create type Identifier64
from bigint
go
Therefore, I change the user defined type for my table declaration and got the table rebuild issue.
Here is a table definition example where I simply change the user defined type:
create table AuditOperationDetails (
AuditOperationDetailID Identifier identity,
AuditOperationID MandatoryFKey not null,
ColumnID MandatoryFKey not null,
PreviousValue sql_variant null
)
go / comments
Hi,
I have the lattest release of Sql Compare 9.0.0.79 Professional Edition and no update are available. This is the only change I made to the table and the article detailed do not apply.
The only ...
You can Do:
SET NOEXEC OFF
Then on Error: @TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
If first taught you had some other error management but after I review it, no magic... maybe you have a reason behind... If so, Pls share... / comments
You can Do:
SET NOEXEC OFF
Then on Error:@TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
GO
If first taught you had some other error management but after I review it, no magic... maybe you have a reason...
The table must be rebuilt issue
Hi,
I am changing a primary identity key type from INT to BIGINT. The generated script is rebuilding the table in this case. SQL server 2005 / 2008 works perfectly with an alter table (there no los...