Learned something new today. Maybe it’s well-known, but new to me, you can just run “C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\1.4\SqlPubWiz.exe”. This nifty little tool can generate INSERT script very easily. Pictures tell the story 🙂
SQL Server 2008 R2 – generating INSERT statements for a table
by community-syndication | Jun 24, 2010 | BizTalk Community Blogs via Syndication