Data Source=.\sqlexpress;Initial Catalog=<source db name>;Integrated Security=True Data Source=.\sqlexpress;Initial Catalog=<destination db name>;Integrated Security=True 30 0 True True False False False False exec sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all'; exec sp_msforeachtable 'ALTER TABLE ? DISABLE TRIGGER all'; exec sp_msforeachtable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all'; exec sp_msforeachtable 'ALTER TABLE ? ENABLE TRIGGER all';