See post SQL 2005 MA: Export and Delta Import.
truncate table dbo.MyTable_Previous
insert into dbo.MyTable_Previous select * from dbo.MyTable
About this blog
This blog started out being about MIIS, but has extended to whatever I happen to be working on - particularly when I've had to struggle through incomplete documentation, blog and forum trawls, and good old trial and error to work through a problem. The posts reflect my own homegrown approach to problems I encountered and are entirely based on my own experiences - I will try to avoid theorising!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.My social media policy
+ I will only accept facebook friend requests from people I know in person.
+ I will only accept linkedin requests from people I have worked with or had at least a few email exchanges with (remind me on the request if this is the case).
+ You are of course welcome to follow me on twitter (@miss_miis).RSS
AD ADAM ADFS Best Practice BPOS Cloud Conferences Email Template Excel Exchange 2003 Exchange 2007 Exchange 2010 FIM 2010 FIM 2010 R2 FIM Sync Service Groups ILM ILM "2" ILM 2007 Logs Lotus Notes MIIS 2003 MiisApp MPR newbie Novell Office 365 OpenLDAP Password Sync Performance Philosophising powershell Quest RCDC Reporting SAP Scripting Sets Sharepoint SQL Uncategorized Unify VB.NET VBScript Windows Server 2003 Windows Server 2008 Workflow
Popular Posts
- A GALSync powershell script
- Adding Exchange 2007 mailboxes to existing user accounts
- Exchange 2007 Cross-Forest Migration
- FIM Walkthroughs – Create the FIM MA
- FIM Walkthroughs – Planning and Installation
- Importing groups from AD to the FIM Portal using classic flow rules
- Password Sync from AD to BPOS
- Powershell Custom WF Activity
- Running Remote Powershell scripts from VB.NET
Pages
Archives
-
Blogroll
- Kim Cameron's Indentity Weblog
Close preview
Loading... - Jackson's Identity Management & Active Directory Reality Tour Travelblog
Close preview
Loading... - Tomek's DS World
Close preview
Loading... - IT Mum
Close preview
Loading... - 1dent1ty cHa0s
Close preview
Loading... - Clint Boessen
Close preview
Loading... - TechNet Flash Feed
Close preview
Loading... - You Had Me At EHLO
Close preview
Loading... - PuttyQ
Close preview
Loading... - Jorge 's Quest For Knowledge!
Close preview
Loading... - FIM / ILM Best Practices
Close preview
Loading... - IdM Crisis
Close preview
Loading... - ADdict
Close preview
Loading... - Anthony Ho
Close preview
Loading... - CShark
Close preview
Loading... - Darryl Russi's Blog
Close preview
Loading... - Gil's Blog
Close preview
Loading... - Identity Management Extensibility
Close preview
Loading... - Identity Underground
Close preview
Loading... - IdM for Real
Close preview
Loading... - Identity Trench
Close preview
Loading... - FIM 2010 Technet Wiki Articles
Close preview
Loading... - Identity Minded
Close preview
Loading...
- Kim Cameron's Indentity Weblog
