User profile for Darren166 – Support

Activity overview Badges (0) Posts (1) Comments (1)

Comments

I have changed the structure of a large database that I had a copy of, I then applied the structure change to the latest copy of the live database which went fine, creating a lot of empty tables. I then did a data comparison to update most of the new tables, but when I run the comparison it fails for the same reason mentioned above, a lot of the constraint removal code is duplicated. The duplication seems to get greater as the code moves further down. Here is an example of the code; -- Drop constraint FK_AWD_WebsiteBrochure_AWD_Website from [dbo].[AWD_WebsiteBrochure] ALTER TABLE [dbo].[AWD_WebsiteBrochure] DROP CONSTRAINT [FK_AWD_WebsiteBrochure_AWD_Website] -- Drop constraint FK_AWD_WebsiteBrochure_AWD_Website from [dbo].[AWD_WebsiteBrochure] ALTER TABLE [dbo].[AWD_WebsiteBrochure] DROP CONSTRAINT [FK_AWD_WebsiteBrochure_AWD_Website] -- Drop constraint FK_AWD_WebsiteBrochure_AWD_Website from [dbo].[AWD_WebsiteBrochure] ALTER TABLE [dbo].[AWD_WebsiteBrochure] DROP CONSTRAINT [FK_AWD_WebsiteBrochure_AWD_Website] -- Drop constraint FK_AWD_ProductGroups_AWD_ProductTypes from [dbo].[AWD_ProductGroups] ALTER TABLE [dbo].[AWD_ProductGroups] DROP CONSTRAINT [FK_AWD_ProductGroups_AWD_ProductTypes] -- Drop constraint FK_AWD_ProductGroups_AWD_ProductTypes from [dbo].[AWD_ProductGroups] ALTER TABLE [dbo].[AWD_ProductGroups] DROP CONSTRAINT [FK_AWD_ProductGroups_AWD_ProductTypes] -- Drop constraint FK_AWD_ProductGroups_AWD_ProductTypes from [dbo].[AWD_ProductGroups] ALTER TABLE [dbo].[AWD_ProductGroups] DROP CONSTRAINT [FK_AWD_ProductGroups_AWD_ProductTypes] -- Drop constraint FK_AWD_ProductGroups_AWD_ProductTypes from [dbo].[AWD_ProductGroups] ALTER TABLE [dbo].[AWD_ProductGroups] DROP CONSTRAINT [FK_AWD_ProductGroups_AWD_ProductTypes] -- Drop constraint FK_AWD_ProductCertifications_AWD_ProductTestingHouse from [dbo].[AWD_ProductGroupCertifications] ALTER TABLE [dbo].[AWD_ProductGroupCertifications] DROP CONSTRAINT [FK_AWD_ProductCertifications_AWD_ProductTestingHouse] -- Drop constraint FK_AWD_ProductCertifications_AWD_ProductTestingHouse from [dbo].[AWD_ProductGroupCertifications] ALTER TABLE [dbo].[AWD_ProductGroupCertifications] DROP CONSTRAINT [FK_AWD_ProductCertifications_AWD_ProductTestingHouse] -- Drop constraint FK_AWD_ProductCertifications_AWD_ProductTestingHouse from [dbo].[AWD_ProductGroupCertifications] ALTER TABLE [dbo].[AWD_ProductGroupCertifications] DROP CONSTRAINT [FK_AWD_ProductCertifications_AWD_ProductTestingHouse] -- Drop constraint FK_AWD_ProductCertifications_AWD_ProductTestingHouse from [dbo].[AWD_ProductGroupCertifications] ALTER TABLE [dbo].[AWD_ProductGroupCertifications] DROP CONSTRAINT [FK_AWD_ProductCertifications_AWD_ProductTestingHouse] -- Drop constraint FK_AWD_Products_AWD_ProductSuppliers from [dbo].[AWD_Products] ALTER TABLE [dbo].[AWD_Products] DROP CONSTRAINT [FK_AWD_Products_AWD_ProductSuppliers] -- Drop constraint FK_AWD_Products_AWD_ProductSuppliers from [dbo].[AWD_Products] ALTER TABLE [dbo].[AWD_Products] DROP CONSTRAINT [FK_AWD_Products_AWD_ProductSuppliers] -- Drop constraint FK_AWD_Products_AWD_ProductSuppliers from [dbo].[AWD_Products] ALTER TABLE [dbo].[AWD_Products] DROP CONSTRAINT [FK_AWD_Products_AWD_ProductSuppliers] -- Drop constraint FK_AWD_Products_AWD_ProductSuppliers from [dbo].[AWD_Products] ALTER TABLE [dbo].[AWD_Products] DROP CONSTRAINT [FK_AWD_Products_AWD_ProductSuppliers] -- Drop constraint FK_AWD_Products_AWD_ProductSuppliers from [dbo].[AWD_Products] ALTER TABLE [dbo].[AWD_Products] DROP CONSTRAINT [FK_AWD_Products_AWD_ProductSuppliers] -- Drop constraint FK_AWD_Products_AWD_ProductStatus from [dbo].[AWD_Products] ALTER TABLE [dbo].[AWD_Products] DROP CONSTRAINT [FK_AWD_Products_AWD_ProductStatus] -- Drop constraint FK_AWD_Products_AWD_ProductStatus from [dbo].[AWD_Products] ALTER TABLE [dbo].[AWD_Products] DROP CONSTRAINT [FK_AWD_Products_AWD_ProductStatus] -- Drop constraint FK_AWD_Products_AWD_ProductStatus from [dbo].[AWD_Products] ALTER TABLE [dbo].[AWD_Products] DROP CONSTRAINT [FK_AWD_Products_AWD_ProductStatus] -- Drop constraint FK_AWD_Products_AWD_ProductStatus from [dbo].[AWD_Products] ALTER TABLE [dbo].[AWD_Products] DROP CONSTRAINT [FK_AWD_Products_AWD_ProductStatus] -- Drop constraint FK_AWD_Products_AWD_ProductStatus from [dbo].[AWD_Products] ALTER TABLE [dbo].[AWD_Products] DROP CONSTRAINT [FK_AWD_Products_AWD_ProductStatus] -- Drop constraint FK_AWD_Products_AWD_ProductStatus from [dbo].[AWD_Products] ALTER TABLE [dbo].[AWD_Products] DROP CONSTRAINT [FK_AWD_Products_AWD_ProductStatus] -- Drop constraint FK_AWD_Products_AWD_ProductStatus from [dbo].[AWD_Products] ALTER TABLE [dbo].[AWD_Products] DROP CONSTRAINT [FK_AWD_Products_AWD_ProductStatus] I reverted to SQLData compare version 3 and it worked fine. Darren / comments

I have changed the structure of a large database that I had a copy of, I then applied the structure change to the latest copy of the live database which went fine, creating a lot of empty tables. ...

0 votes

Total activity: 3
Last activity: February 05, 2025 17:24
Member since: February 05, 2025 10:10

Following: 0 users
Followed by: 0 users
Votes: 0
Subscriptions: 1