Comments
Sort by recent activity
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...
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...