On 7/24/06, Russ <[EMAIL PROTECTED]> wrote: > We're trying to move to SQL 2005 Express from SQL 2k Standard. The only > thing that seems to be missing from our perspective is DTS, and the only way > we really use DTS is to copy tables from one db to another. Is there a way > to do that using SQL and/or third party tools? We'd like to be able to copy > table along with primary keys/indexes, so a simple select * into table won't > work.
There are probably quite a few ways to do this, but I'll throw one out there. I've been pretty impressed with Aqua Data Studio (http://www.aquafold.com/). The interface is similar to Enterprise Manager, with some nice additions. You might be able to make use of its ability to create export scripts which have a create table statement and insert statements for the data (similar to what mysqldump does). The create statements have the keys/indexes defined. And it will work with most popular databases out there (I'm using it for SQL 2005, SQL 2000 and MySQL 4 and 5...not sure if it will work with SQL 2005 Express). -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247573 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
