Skip to content

missmiis

Adventures in identity management

SQL Query: Archive Current table to Previous

See post SQL 2005 MA: Export and Delta Import.

truncate table dbo.MyTable_Previous
insert into dbo.MyTable_Previous
select * from dbo.MyTable

Share this:

  • Twitter
  • Facebook

About this blog

My real world experiences building solutions with Microsoft Identity Manager and it’s previous incarnations.

For information about my book, see IT Grrrl.

Copyright Notice

All text in this blog is original and the copyright is owned by the author. You are welcome to use the code (without warranty) but please do not copy the articles without asking first.

Categories

Archives

Proudly powered by WordPress