Activity overview
Latest activity by Johan Van Hoye
Jonathan,
I'm seeing the same thing whether or not that option is checked.
Left:
CREATE TABLE [dbo].[t_trn_warranty]
(
[entity] [d_entity] NOT NULL,
[organisation_code] [d_organisation_code] NOT NULL,
[warranty_nr] [d_warranty_nr] NOT NULL,
[year] [d_year] NOT NULL,
[period] [d_period] NOT NULL,
[customer_nr] [d_customer_nr] NOT NULL,
[related_deal_id] [d_deal_id] NOT NULL,
[warranty_type] [d_warranty_type] NOT NULL,
[status] [d_status] NOT NULL,
[party_id] [d_party_id] NOT NULL,
[currency] [d_currency] NOT NULL,
[ccy_amount] [d_amount] NOT NULL,
[lcl_amount] [d_amount] NOT NULL,
[begin_date] [datetime] NOT NULL,
[expiry_date] [datetime] NULL,
[audit_date] [datetime] NOT NULL,
[audit_user] [sysname] NOT NULL
)
GO
right:
CREATE TABLE [dbo].[t_trn_warranty]
(
[entity] [d_entity] NOT NULL,
[organisation_code] [d_organisation_code] NOT NULL,
[warranty_nr] [d_warranty_nr] NOT NULL,
[start_validity_date] [datetime] NOT NULL DEFAULT ('19000101'),
[end_validity_date] [datetime] NOT NULL DEFAULT ('99991231'),
[related_deal_id] [d_deal_id] NOT NULL,
[customer_nr] [d_customer_nr] NOT NULL,
[book_code] [d_book_code] NOT NULL,
[year] [d_year] NOT NULL,
[period] [d_period] NOT NULL,
[source_system] [d_source_system] NOT NULL,
[warranty_type] [d_warranty_type] NOT NULL,
[status] [d_status] NOT NULL,
[party_id] [d_party_id] NOT NULL,
[currency] [d_currency] NOT NULL,
[ccy_amount] [d_amount] NOT NULL,
[lcl_amount] [d_amount] NOT NULL,
[begin_date] [datetime] NOT NULL,
[expiry_date] [datetime] NULL,
[last_modified] [datetime] NOT NULL DEFAULT (getdate()),
[modified_by] [sysname] NOT NULL DEFAULT (suser_sname())
)
GO
the field "customer_nr" shows up as new/missing either way.
This is on a SQL2000 SP4 with collation Latin1_general_bin. / comments
Jonathan,
I'm seeing the same thing whether or not that option is checked.
Left:
CREATE TABLE [dbo].[t_trn_warranty]
(
[entity] [d_entity] NOT NULL,
[organisation_code] [d_organisation_code] NOT NU...
Support for free-form object filter?
Hi,
I have a fairly large database schema -- around 700 tables
SQL Compare (and the reports it generates) becomes fairly slow with that size database.
We use a naming convention to logically group ...
Manually match two tables
I'd like to be able to "tell" the comparison engine that a table exists both in source and in destination databases but has a different name.
This is to avoid objects showing up as "New" on the one...
Ignore column order?
Can I somehow indicate that I do not want to mark a different column order between two tables in two databases as a difference?
Thanks
Since you're asking [image]
Here are a couple pain points in my experience:
- A sql compare between two large databases takes about half hour. (+/- 7500 objects)
- Report to HTML is not usable on this size of database because the produced report causes more than 1,5 GB memory allocation by the browser before it collapses the system.
- Resize: Choose Tables And Views in SQL Data compare wizard / comments
Since you're asking
Here are a couple pain points in my experience:
- A sql compare between two large databases takes about half hour. (+/- 7500 objects)
- Report to HTML is not usable on this siz...
Wizard Resizing
Hope this is the right place for submitting a change request.
Although I agree the wizard-approach taken in sql bundle is probably the best approach in terms of offering user-friendly guidance, and...
Object decryption Permission Level
I could not find anything in the online documentation relating to how SQL Compare does its decrypting of encrypted stored procedures. More specifically I would like to know whether this feature req...