User profile for Neil Davidson

Spike, There should be an entry for the server components in the add/remove programs control panel applet on the server. There will be one for each instance they are installed on. This will remove extended stored procedures, service and all binaries from the server. - Neil / comments

Spike, There should be an entry for the server components in the add/remove programs control panel applet on the server. There will be one for each instance they are installed on. This will remove ...

0 votes

Roumen, SQL Compare treats primary keys as a type of index so it is not scripting these because of the options you have set. Can you try unchecking the option 'Ignore indexes'. I would actually recommend you restore the options to the defaults. Yours, Neil defaults "Roumen Stoyanov" <Roumen.Stoyanov@childrens.harvard.edu> wrote in message news:eFsRbZ0PEHA.2140@server53... > Neil, > > I don't have that option. Please see the attached file for options I have > and their settings. The script generated with those options is: > > CREATE TABLE [dbo].[ReportDef] > ( > [OID] [varchar] (100) NOT NULL, > [Name] [varchar] (250) NOT NULL, > [SpName] [varchar] (50) NULL, > [CustomUri] [varchar] (250) NULL, > [SecurityRoleOID] [varchar] (100) NULL, > [Description] [varchar] (500) NULL, > [ReportType] [varchar] (10) NOT NULL CONSTRAINT [DF_Report_type_oid] DEFAULT > ('generic') > ) > > GO > > -- Constraints and indexes > ALTER TABLE [dbo].[ReportDef] ADD CONSTRAINT [CK_Report_ReportType] CHECK > (([ReportType] = 'custom' or [ReportType] = 'generic')) > GO > > -- Foreign keys > ALTER TABLE [dbo].[ReportDef] ADD CONSTRAINT [FK_ReportDef_SecurityRole] > FOREIGN KEY ([SecurityRoleOID]) REFERENCES [dbo].[SecurityRole] ([OID]) ON > UPDATE CASCADE > GO > > > "Neil Davidson" <neil.davidson@red-gate.com> wrote in message > news:dX9iID0PEHA.2168@server53... > > Roumen, > > > > Can you check that the option to include primary keys is checked. > > > > If it still doesn't work, is there any chance you can take snapshots of > the > > two databases, zip them up and e-mail them to me at support@red-gate.com? > Do > > not post them in this forum. > > > > Thanks, > > > > Neil > > "Roumen Stoyanov" <Roumen.Stoyanov@childrens.harvard.edu> wrote in message > > news:8myf5UpPEHA.3156@server53... > > > Brian, > > > > > > I've attached the script file SQL Compare created for my table and there > > is > > > no primary key in there being scripted. I did run it in SQL Analyzer and > > the > > > table it created has no PK. I believe I had the same issue with the > > previous > > > version of SQL Compare and was under the impression that it is a bug you > > are > > > fixing in the latest release. > > > Thank you. > > > > > > Roumen Stoyanov > > > > > > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message > > > news:7wE7e6oPEHA.1220@server53... > > > > Hi Roumen, > > > > > > > > Maybe SQL Compare is simply still scripting the keys out of order. > > It > > > > needs to drop the foreign key before it can modify a primary key > that's > > on > > > > the same column. Can you please check the SQl Compare migration script > > to > > > > ensure that the keys are both being scripted? > > > > > > > > Thanks! > > > > > > > > Regards, > > > > > > > > Brian Donahue > > > > Red Gate Technical Support > > > > > > > > "Roumen Stoyanov" <Roumen.Stoyanov@childrens.harvard.edu> wrote in > > message > > > > news:4r3ajbePEHA.2140@server53... > > > > > I am trying to synch tables, but SQL Compare (3.1.6.210) doesn't > > script > > > > the > > > > > primary keys of the tables. It does, however, script foreign keys > > > causing > > > > > the script to fail when other tables are scripted. The following > table > > > has > > > > > the OID filed set as Primary Key in the database. > > > > > > > > > > CREATE TABLE [dbo].[ReportDef] > > > > > ( > > > > > [OID] [varchar] (100) NOT NULL, > > > > > [Name] [varchar] (250) NOT NULL, > > > > > [SpName] [varchar] (50) NULL, > > > > > [CustomUri] [varchar] (250) NULL, > > > > > [SecurityRoleOID] [varchar] (100) NULL, > > > > > [Description] [varchar] (500) NULL, > > > > > [ReportType] [varchar] (10) NOT NULL CONSTRAINT [DF_Report_type_oid] > > > > DEFAULT > > > > > ('generic') > > > > > ) > > > > > ALTER TABLE [dbo].[ReportDef] ADD > > > > > CONSTRAINT [FK_ReportDef_SecurityRole] FOREIGN KEY > ([SecurityRoleOID]) > > > > > REFERENCES [dbo].[SecurityRole] ([OID]) ON UPDATE CASCADE > > > > > > > > > > Thank you. > > > > > > > > > > Roumen Stoyanov > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > / comments

Roumen, SQL Compare treats primary keys as a type of index so it is not scripting these because of the options you have set. Can you try unchecking the option 'Ignore indexes'. I would actually rec...

0 votes

Roumen, Can you check that the option to include primary keys is checked. If it still doesn't work, is there any chance you can take snapshots of the two databases, zip them up and e-mail them to me at support@red-gate.com? Do not post them in this forum. Thanks, Neil "Roumen Stoyanov" <Roumen.Stoyanov@childrens.harvard.edu> wrote in message news:8myf5UpPEHA.3156@server53... > Brian, > > I've attached the script file SQL Compare created for my table and there is > no primary key in there being scripted. I did run it in SQL Analyzer and the > table it created has no PK. I believe I had the same issue with the previous > version of SQL Compare and was under the impression that it is a bug you are > fixing in the latest release. > Thank you. > > Roumen Stoyanov > > "Brian Donahue (Red Gate)" <brian.donahue@red-gate.com> wrote in message > news:7wE7e6oPEHA.1220@server53... > > Hi Roumen, > > > > Maybe SQL Compare is simply still scripting the keys out of order. It > > needs to drop the foreign key before it can modify a primary key that's on > > the same column. Can you please check the SQl Compare migration script to > > ensure that the keys are both being scripted? > > > > Thanks! > > > > Regards, > > > > Brian Donahue > > Red Gate Technical Support > > > > "Roumen Stoyanov" <Roumen.Stoyanov@childrens.harvard.edu> wrote in message > > news:4r3ajbePEHA.2140@server53... > > > I am trying to synch tables, but SQL Compare (3.1.6.210) doesn't script > > the > > > primary keys of the tables. It does, however, script foreign keys > causing > > > the script to fail when other tables are scripted. The following table > has > > > the OID filed set as Primary Key in the database. > > > > > > CREATE TABLE [dbo].[ReportDef] > > > ( > > > [OID] [varchar] (100) NOT NULL, > > > [Name] [varchar] (250) NOT NULL, > > > [SpName] [varchar] (50) NULL, > > > [CustomUri] [varchar] (250) NULL, > > > [SecurityRoleOID] [varchar] (100) NULL, > > > [Description] [varchar] (500) NULL, > > > [ReportType] [varchar] (10) NOT NULL CONSTRAINT [DF_Report_type_oid] > > DEFAULT > > > ('generic') > > > ) > > > ALTER TABLE [dbo].[ReportDef] ADD > > > CONSTRAINT [FK_ReportDef_SecurityRole] FOREIGN KEY ([SecurityRoleOID]) > > > REFERENCES [dbo].[SecurityRole] ([OID]) ON UPDATE CASCADE > > > > > > Thank you. > > > > > > Roumen Stoyanov > > > > > > > > > > > > > / comments

Roumen, Can you check that the option to include primary keys is checked. If it still doesn't work, is there any chance you can take snapshots of the two databases, zip them up and e-mail them to m...

0 votes

Adam, Can you let me know what hardware you're running it on please (type of processor, number of processors, clock speed, O/S, whether it's a virtual machine etc.) - Neil / comments

Adam, Can you let me know what hardware you're running it on please (type of processor, number of processors, clock speed, O/S, whether it's a virtual machine etc.) - Neil

0 votes

Olaf, On German systems it will run on German; in English, English. If you want to run multiple languages then you can use the Windows Multilanguage User Interface (MUI) pack. If you don't want the German install then deleting the de subdirectory in program files\red gate\sql bundle should do the trick. / comments

Olaf, On German systems it will run on German; in English, English. If you want to run multiple languages then you can use the Windows Multilanguage User Interface (MUI) pack. If you don't want the...

0 votes

Hi, You can get it from here: http://www.red-gate.com/products/sql_dependency_viewer/ We're currently working on version 2 - it should be in beta in the next 2 months. / comments

Hi, You can get it from here:http://www.red-gate.com/products/sql_dependency_viewer/ We're currently working on version 2 - it should be in beta in the next 2 months.

0 votes

Hi, We'll be e-mailing all current customers and people subscribed to our newsletter once the new version is released. It should be in the next few days. / comments

Hi, We'll be e-mailing all current customers and people subscribed to our newsletter once the new version is released. It should be in the next few days.

0 votes

SQL Compare 4.0 (in beta - http://www.red-gate.com/products/sql_bu ... e_beta.htm) will take account of the extra brackets in SQL 2005 and not mark those two defaults as different (although they will still appear different in the side by side text, since this is essentially just a textual diff). / comments

SQL Compare 4.0 (in beta - http://www.red-gate.com/products/sql_bu ... e_beta.htm) will take account of the extra brackets in SQL 2005 and not mark those two defaults as different (although they wi...

0 votes

The new system objects will be filtered out in the final release of 4.x as well. / comments

The new system objects will be filtered out in the final release of 4.x as well.

0 votes

Hi, Can you tell me where your temp directory is please. You can find this out by going to a command line prompt and typing SET to see what the TMP and TEMP variables are set to. / comments

Hi, Can you tell me where your temp directory is please. You can find this out by going to a command line prompt and typing SET to see what the TMP and TEMP variables are set to.

0 votes

How can we help you today?

Neil Davidson

Comments