Activity overview
Latest activity by ziotempa76
ok, here they are:
sql7
CREATE TABLE [dbo].[CROSS_BENEFIT]
(
[IDCROSSBENEFIT] [int] NOT NULL IDENTITY(1, 1),
[IDBENEFIT] [int] NOT NULL,
[IDCOUNTRY] [int] NOT NULL,
[IDTYPEDIMENSIONGROUP] [int] NOT NULL,
[DATASENSE] [int] NOT NULL,
[NUMEROSITY] [int] NULL,
[PERCENTAGE] [real] NULL
)
sql2005
CREATE TABLE [dbo].[CROSS_BENEFIT]
(
[IDCROSSBENEFIT] [int] NOT NULL,
[IDBENEFIT] [int] NOT NULL,
[IDCOUNTRY] [int] NOT NULL,
[IDTYPEDIMENSIONGROUP] [int] NOT NULL,
[DATASENSE] [int] NOT NULL,
[NUMEROSITY] [int] NULL,
[PERCENTAGE] [real] NULL
)
These are the tables, SQL Compare highlights IDENTITY(1, 1)
in the options I checked, beyond the default options,
'Constraint and index names'
'Identity seed and increment values'
'Collations'
'Indentity properties'
thank you / comments
ok, here they are:
sql7
CREATE TABLE [dbo].[CROSS_BENEFIT]
(
[IDCROSSBENEFIT] [int] NOT NULL IDENTITY(1, 1),
[IDBENEFIT] [int] NOT NULL,
[IDCOUNTRY] [int] NOT NULL,
[IDTYPEDIMENSIONGROUP] [int] NOT...
comparison options between sql7 and sql2000
hi, I'm testing the trial version of sql compare. I have a problem and I don't know how to manage it. I have a sql7 db which I have to synch with a sql2005 which is the production server. I'm compa...