Most RecentMost ViewedMost LikesSQL 2019 SMO We have a SQL 2019 server installed. The application we want to use has a requirement of installing SQL 2014 SMO on the SQL server. Is there an updated version for SQL 2019 available? We don't want to use SQL 2014 components on our newly installed SQL servers. I can't seem to find a specific version for SQL 2019, maybe it isn't available. SolvedRoll your own Transfer SQL Server Objects taskFirst published on MSDN on Apr 18, 2007 Awhile back we went through a lot of customer feedback logged through the Connect site concerning the Transfer SQL Server Objects task.Transfering a couple of tables at a timeFirst published on MSDN on Oct 31, 2007 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.DANGER! DropObjectsFirst and CopyAllObjects on the same serverFirst published on MSDN on Feb 28, 2007 A post in the forums had me try out what turned to be a dangerous combination of flags in the Transfer SQL Objects task.
