How can we help you today? How can we help you today?
Neil Davidson
Activity overview Badges (0) Posts (39) Comments (126)

Comments

Sort by recent activity
Keith, I apologise for the time it's taken to sort this out. We're going to work on a patch to add an 'Ignore users' option so we can get this working. This will take a few days. In the short term, there are a couple of options: 1) You could set the options to ignore all permissions 2) You could remove the ASPNET and KBARROWS users' permissions and set up an ASP and MYUSERS groups, add the users to those groups, and then set the permissions for those groups. You will still need to edit the script, but only 1 line. The second option is probably the best - it will make it a lot easier in the future for you. - Neil / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Local Accounts break the compare
Keith, I apologise for the time it's taken to sort this out. We're going to work on a patch to add an 'Ignore users' option so we can get this working. This will take a few days. In the short term,...
0 votes
We're hoping for some time next week or so. Out of interest, where did you read that DBCC TRACEON(3604) causes problems? It should only change an informational setting for the current connection. It shouldn't cause performance issues / crash the server. / comments
  1. Community
  2. SQL Compare Previous Versions
  3. DBCC TRACEON 3604
We're hoping for some time next week or so. Out of interest, where did you read that DBCC TRACEON(3604) causes problems? It should only change an informational setting for the current connection. I...
0 votes
Toby, It could well be sysdepends - it's notoriously unreliable. I'm not sure of any utilities to rebuild it - maybe try google groups? Is the foreign key error the first error that occurs when you run the scripts, or are there errors previous to that? - Neil "Toby Harman" <toby.harman@morningstar.com.au> wrote in message news:hkv3aA$SDHA.2424@server53... > Hi Neil > > Yes - The whole database is selected. and Yes, using the ! button to create > the script. > > The problem may be more in the area of the sysdepends table. I am not > convinced that this is adequately maintained. Are you aware of any utilities > to rebuild sysdepends? > > Also - The script will run if I partition it up I am not sure if the problem > is related to the script of a server setting on SQL which is not committing > the transactions as it should. > > Toby > > "Neil Davidson" <neil.davidson@red-gate.com> wrote in message > news:shj91UJRDHA.1456@server53... > > Toby, > > > > Are you generating the scripts from the ! toolbar icon? Also, have you > tried > > selecting the table that the foreign key references to include that in the > > script as well? > > > > Yours, > > > > Neil Davidson > > "Toby Harman" <toby.harman@morningstar.com.au> wrote in message > > news:rCPumucQDHA.1908@server53... > > > Forgot to mention - Red-Gate SQL-Compare 2.03 - Trial Version! > > > > > > "Toby Harman" <toby.harman@morningstar.com.au> wrote in message > > > news:qe9M53QQDHA.1156@server53... > > > > Hi All > > > > > > > > First - Congrats to Red-Gate and the developers for developing a > > seriously > > > > useful tool. > > > > > > > > Now - I have a small problem! > > > > > > > > It would appear that the script (which I accept will only be 95% > > > successful) > > > > has a small problem. > > > > > > > > If there are two databases which contain the same table and a new > column > > > is > > > > added to a table in one database it doesn't handle Foreign Keys very > > well. > > > > They don't appear to be dropped before the new table is created, and > > thus > > > > the old table cannot be dropped and the new table cannot be renamed > into > > > > place. > > > > > > > > Is this a known bug or am I doing something wrong? > > > > > > > > Thanks > > > > > > > > Toby > > > > > > > > > > > > > > > > > > > > / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Foreign Key Constraints not handled
Toby, It could well be sysdepends - it's notoriously unreliable. I'm not sure of any utilities to rebuild it - maybe try google groups? Is the foreign key error the first error that occurs when you...
0 votes
Can you confirm that the tables have a primary key / unique index on them? SQL Data Compare requires one of these to work. - Neil / comments
  1. Community
  2. SQL Data Compare Previous Versions
  3. No tables to compare
Can you confirm that the tables have a primary key / unique index on them? SQL Data Compare requires one of these to work. - Neil
0 votes
Vince, I have e-mailed you separately about this. - Neil / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Trial Has expired
Vince, I have e-mailed you separately about this. - Neil
0 votes
Can you specify a DEFAULT value for those columns? / comments
  1. Community
  2. SQL Compare Previous Versions
  3. Suppress Compare Errors
Can you specify a DEFAULT value for those columns?
0 votes
Total activity
256
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
91