I believe there is a command line utility in Express and that the old DTS is available, but you have to dig up the executable buried in the install directory.
To be honest I've never managed to get it to work, but didn't try too hard. They sure did try hard to bury that rather useful tool in 2005!! If you find the answer...please post back ;-) HTH Cheers On Wed, 2010-07-21 at 13:35 -0400, Michael Dinowitz wrote: > I'm trying to move a table from one sql 2005 database to another and > it just doesn't seem like an easy operation. In sql 2000 it was a > simple export/import. > Is there a better tool than the sql studio manager express? > > Thanks > > -- > Michael Dinowitz > Lead Author - Adobe Coldfusion Anthology > http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3359 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
