Move inactive rows to achive table via SQL statements

Check this link if you want to generate automated migrated scripts:
http://eyearchive.codeplex.com/
or create your own migration scripts.

Let’s consider the two tables:

We need a clear, transactional way to move rows from the active to the inactive tickets table.

Solution 1:

Solution 2:

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.