Synchronization Failure
mpascoe
Posts: 5
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
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
This discussion has been closed.
Comments
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.
Thanks for your reply. Yes, this option is definitely turned on.
Regards,
Matthew