Copy records from one table to another with triggers firing
I can't seem to find out how to copy rows from one table to another and have the triggers fire. I have tried the do an insert into, but it wants to insert into a new table instead of an existing one. The DTS copy doesn't give the option to do a slow copy or to use the "fire_triggers" option.
Any ideas? The tables are exactly the same except one has an insert trigger that needs to fire.
Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!