Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SMO   (RSS)

Transfering a couple of tables at a time

I missed some of the comments to my post about creating your own Transfer SQL Objects Task with a script task , so I thought I'd post the answer here incase people miss my answer. You can use the ObjectList property of the Transfer object to specify which
Posted by mmasson | 1 Comments
Filed under: ,

Roll your own Transfer SQL Server Objects task

Awhile back we went through a lot of customer feedback logged through the Connect site concerning the Transfer SQL Server Objects task. Some of these turned out to be bugs, but a lot of the reported issues stemmed from usability problems with the task
Posted by mmasson | 12 Comments
Filed under: , ,

DANGER! DropObjectsFirst and CopyAllObjects on the same server

A post in the forums had me try out what turned to be a dangerous combination of flags in the Transfer SQL Objects task. The user said they were no longer able to access their database after running their package, and I was curious as to why this would
Posted by mmasson | 0 Comments
Filed under:
 
Page view tracker