Temporarily ignore or turn-off restraints, import data, then turn them back on?

print 'begin delete'
DELETE FROM [UNAdmin].[ApplicationComponents]
DELETE FROM [UNAdmin].[ApplicationComponentTexts]
DELETE FROM [UNAdmin].[ApplicationFeatures]
DELETE FROM [UNAdmin].[ApplicationFeatureTexts]
DELETE FROM [UNAdmin].[ApplicationModules]
DELETE FROM [UNAdmin].[ApplicationModuleTexts]
DELETE FROM [UNAdmin].[ApplicationResources]
DELETE FROM [UNAdmin].[ApplicationSettings]   
DELETE FROM [UNAdmin].[ApplicationLanguages]   
GO
print 'end delete'


print 'begin app resources'
INSERT [UNAdmin].[ApplicationResources] ([ID], [Description], [Value], [RecordCreated], [RecordModified]) VALUES (1, N'Union ID', N'UBC ID', CAST(N'2011-02-12 06:35:11.520' AS DateTime), CAST(N'2011-02-12 06:35:11.520' AS DateTime))
GO
print 'end app resources'

print 'begin with app settings'
INSERT [UNAdmin].[ApplicationSettings] ([ID], [Description], [Value], [RecordCreated], [RecordModified]) VALUES (1, N'Show Help', 0, CAST(N'2011-02-12 06:35:27.870' AS DateTime), CAST(N'2011-02-12 06:35:27.870' AS DateTime))
GO
print 'end app settings'

print 'begin app languages'
INSERT [UNAdmin].[ApplicationLanguages] ([ID], [Name], [IsDeleted], [RecordCreated], [RecordModified]) VALUES (1, N'English', 1, CAST(N'2015-04-09 21:28:57.773' AS DateTime), CAST(N'2015-04-09 21:28:57.773' AS DateTime))
GO
print 'end app languages'

print 'begin app comp texts'
INSERT [UNAdmin].[ApplicationComponentTexts] ([ID], [LanguageID], [Text], [IsDeleted], [RecordCreated], [RecordModified]) VALUES (1, 1, N'Dashboard', 0, CAST(N'2010-01-23 08:33:56.233' AS DateTime), CAST(N'2010-01-23 08:33:56.233' AS DateTime))
GO
print 'end app comp texts'

print 'begin app feat texts'
INSERT [UNAdmin].[ApplicationFeatureTexts] ([ID], [LanguageID], [Text], [IsDeleted], [RecordCreated], [RecordModified]) VALUES (1, 1, N'My Bulletin Board', 0, CAST(N'2010-01-23 08:33:56.250' AS DateTime), CAST(N'2010-01-23 08:33:56.250' AS DateTime))
GO
print 'end app feat texts'

print 'begin app comps'
INSERT [UNAdmin].[ApplicationComponents] ([ID], [TextID], [SortOrder], [ModuleID], [DefaultFeatureID], [SecurityResourceRightID], [IsEnabled], [IsDeleted], [RecordCreated], [RecordModified]) VALUES (1, 1, 1, NULL, 38, 1, 1, 0, CAST(N'2010-01-23 08:33:56.250' AS DateTime), CAST(N'2010-01-23 08:33:56.250' AS DateTime))
GO
print 'end app comps'

print 'begin app features'
INSERT [UNAdmin].[ApplicationFeatures] ([ID], [TextID], [ComponentID], [SortOrder], [URL], [SecurityResourceRightID], [IsEnabled], [IsDeleted], [RecordCreated], [RecordModified]) VALUES (1, 1, 1, 2, N'/Common/DashboardClerical.aspx', 9, 1, 0, CAST(N'2010-01-23 08:33:56.250' AS DateTime), CAST(N'2010-01-23 08:33:56.250' AS DateTime))
GO
print 'end app features'




print 'end all processing'

Select allOpen in new window

begin delete

(0 row(s) affected)

(1 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
end delete
begin app resources

(1 row(s) affected)
end app resources
begin with app settings

(1 row(s) affected)
end app settings
begin app languages

(1 row(s) affected)
end app languages
begin app comp texts

(1 row(s) affected)
end app comp texts
begin app feat texts

(1 row(s) affected)
end app feat texts
begin app comps
Msg 547, Level 16, State 0, Line 4
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ApplicationComponents_ApplicationFeatures". The conflict occurred in database "NCCRC_Onebox_tom", table "UNAdmin.ApplicationFeatures", column 'ID'.
The statement has been terminated.
end app comps
begin app features
Msg 547, Level 16, State 0, Line 4
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ApplicationFeatures_ApplicationComponents". The conflict occurred in database "NCCRC_Onebox_tom", table "UNAdmin.ApplicationComponents", column 'ID'.
The statement has been terminated.
end app features
end all processing

Select allOpen in new window