When doing data imports for new customers, you will need to reset the database between each pass. In order to clear the old data, but keep the company setups you will need to use the script below on the customer data base:
--truncate TABLE dbo.aForteTransactionInvoice
--SELECT * FROM sdealer
BEGIN TRAN
UPDATE dbo.aWorkOrder
SET InvoiceId = NULL
UPDATE dbo.aInvoice
SET WorkOrderId = NULL
UPDATE dbo.aCalendarAppointment
SET WorkOrderAppointmentId = NULL
DELETE FROM dbo.aCustomerVisitedDetail
DELETE FROM dbo.aCustomerTerm
DELETE FROM dbo.cf_Recipient
DELETE FROM dbo.cf_InstanceStage
DELETE FROM dbo.cf_FormInstance
DELETE FROM dbo.cf_PackageInstance
DELETE FROM dbo.aCalendarTechnician
DELETE FROM aRmrGeneration
DELETE FROM aRmrBatch
DELETE FROM aRmrRateChange
DELETE FROM aGLEntryDetail
DELETE FROM aGLEntry
DELETE FROM dbo.aRecurringWorkOrderBatch
DELETE FROM dbo.aOutgoingEmail
DELETE FROM dbo.aOutgoingMail
DELETE FROM dbo.aCustomerSiteAuthority
DELETE FROM dbo.aCalendarEmployee
DELETE FROM dbo.aCalendarAppointment
DELETE FROM dbo.aForteTransactionInvoice
DELETE FROM dbo.aForteTransaction
DELETE FROM dbo.aEstimateAttachment
DELETE FROM dbo.aEstimateItem
DELETE FROM dbo.aEstimatePart
DELETE FROM dbo.aEstimateRMR
DELETE FROM dbo.aEstimate
DELETE FROM dbo.aRecurringWorkOrderBatch
DELETE FROM dbo.aWorkOrderItem
DELETE FROM dbo.aWorkOrderPart
DELETE FROM dbo.aWorkOrderAppointment
DELETE FROM dbo.aWorkOrderRMR
DELETE FROM dbo.aWorkOrder
DELETE FROM dbo.aECheck
DELETE FROM dbo.aCreditCard
DELETE FROM dbo.aRecurringWorkOrder
DELETE FROM dbo.aOutgoingMail
DELETE FROM dbo.aPaymentApplied
DELETE FROM dbo.aPayment
DELETE FROM dbo.aDeposit
DELETE FROM dbo.aSalesTaxDetail
DELETE FROM dbo.aCreditApplied
DELETE FROM dbo.aInvoiceDetail
DELETE FROM dbo.aInvoice
DELETE FROM dbo.aCustomerDocument
DELETE FROM dbo.aCustomerContactJoin
DELETE FROM dbo.aCustomerContact
DELETE FROM dbo.aCustomerRecurringTracking
DELETE FROM dbo.aCustomerRecurring
DELETE FROM dbo.aCustomerSystemPart
DELETE FROM dbo.aZone
DELETE FROM dbo.sa_aLead
DELETE FROM dbo.sa_aDepartmentEmployee
DELETE FROM dbo.sa_aDepartmentManager
DELETE FROM dbo.sa_aDepartment
DELETE FROM dbo.sa_aSalesPackageItem
DELETE FROM dbo.sa_aSalesPackagePart
DELETE FROM dbo.sa_aSalesPackageRMR
DELETE FROM dbo.sa_aSalesPackageCommission
DELETE FROM dbo.sa_aSalesPackage
DELETE FROM dbo.aCustomerSystem
DELETE FROM dbo.aCustomerSite
DELETE FROM dbo.aCustomer
DELETE FROM dbo.aNote
DELETE FROM dbo.[Log]
DELETE FROM dbo.TrackingLog_Parent_Child
DELETE FROM dbo.TrackingLogDifference
DELETE FROM dbo.TrackingLog
DBCC CHECKIDENT ( 'dbo.aCustomerVisitedDetail',RESEED,1)
DBCC CHECKIDENT ( 'dbo.aCustomerTerm',RESEED,1)
DBCC CHECKIDENT ( 'dbo.cf_Recipient',RESEED,1)
DBCC CHECKIDENT ( 'dbo.cf_InstanceStage',RESEED,1)
DBCC CHECKIDENT ( 'dbo.cf_FormInstance',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.cf_PackageInstance',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCalendarTechnician',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aRmrGeneration',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aRmrBatch',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aRmrRateChange',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aGLEntryDetail',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aGLEntry',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aRecurringWorkOrderBatch',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aZone',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aOutgoingEmail',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aOutgoingMail',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCustomerSiteAuthority',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCalendarAppointment',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCalendarEmployee',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aECheck',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCreditCard',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aRecurringWorkOrder',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aEstimateAttachment',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aEstimateItem',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aEstimatePart',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aEstimateRMR',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aEstimate',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aNote',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aForteTransactionInvoice',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aForteTransaction',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aPaymentApplied',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aPayment',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aDeposit',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aOutgoingMail',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aRecurringWorkOrderBatch',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aWorkOrderItem',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aWorkOrderPart',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aWorkOrderAppointment',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aWorkOrderRMR',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aWorkOrder',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aSalesTaxDetail',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCreditApplied',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aInvoiceDetail',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aInvoice',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCustomerContactJoin',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCustomerContact',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCustomerDocument',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCustomerRecurringTracking',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCustomerRecurring',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCustomerSystemPart',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCustomerSystem',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCustomerSite',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.aCustomer',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.[Log]',RESEED, 1)
DBCC CHECKIDENT ( 'dbo.TrackingLog_Parent_Child', RESEED, 1)
DBCC CHECKIDENT ( 'dbo.TrackingLogDifference', RESEED, 1)
DBCC CHECKIDENT ( 'dbo.TrackingLog', RESEED, 1)
DBCC CHECKIDENT ( 'dbo.sa_aDepartment', RESEED, 1)
DBCC CHECKIDENT ( 'dbo.sa_aDepartmentEmployee', RESEED, 1)
DBCC CHECKIDENT ( 'dbo.sa_aDepartmentManager', RESEED, 1)
DBCC CHECKIDENT ( 'dbo.sa_aSalesPackage', RESEED, 1)
DBCC CHECKIDENT ( 'dbo.sa_aSalesPackageItem', RESEED, 1)
DBCC CHECKIDENT ( 'dbo.sa_aSalesPackagePart', RESEED, 1)
DBCC CHECKIDENT ( 'dbo.sa_aSalesPackageRMR', RESEED, 1)
DBCC CHECKIDENT ( 'dbo.sa_aSalesPackage', RESEED, 1)
DBCC CHECKIDENT ( 'dbo.sa_aLead', RESEED, 1)
--COMMIT TRAN
--ROLLBACK TRAN
