How can we help you today? How can we help you today?

Synchronization Failure

I get the following error while trying to update a database:

The following error message was returned from the SQL Server:

[5074] The column 'units_available' is dependent on column 'units_on_hand'.
ALTER TABLE ALTER COLUMN units_on_hand failed because one or more objects access this column.

The following SQL command caused the error:

ALTER TABLE [dbo].[product_location] ALTER COLUMN [units_on_hand] [int] NULL
ALTER TABLE [dbo].[product_location] ALTER COLUMN [units_allocated] [int] NULL
ALTER TABLE [dbo].[product_location] ALTER COLUMN [units_on_replenishment] [int] NULL


Any idea on how I can overcome this problem and synch this database?

Thanks for any help

Matthew Pascoe
mpascoe
0

Comments

3 comments

Sort by
  • Brian Donahue
    Hello Matthew,

    The very first suggestion that I have is to make sure that you've compared the databases with the 'include dependent objects' option turned on in the options menu. This causes SQL Compare to create scripts that will automatically modify objects in dependency order.
    Brian Donahue
    0
  • mpascoe
    Hi Brian,

    Thanks for your reply. Yes, this option is definitely turned on.

    Regards,
    Matthew
    mpascoe
    0
  • Brian Donahue
    Is units_on_hand a column in the same table as the units_available column?
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.