[dba-SQLServer] Any gut feelings?

Maybe that was back in the day when I couldn't see the servers from each
other.  I THINK I have solved that issue so maybe it will work for me now.

But... Does it actually transfer the whole shebang - field type, data,
indexes etc?  Or just a generic "here's your data, now you fix it back up"?
So far I have only successfully used DTS to export CSV files which of course
promptly loses all the good stuff.

Well, my problems aren't completely solved.  I can see the database on the
new SBS server from the other old server, but not VV.  Whatever.  I switch
to the old server and run the DTS wizard and the table does indeed transfer,
DAMNED quickly too!

PKs and indexes did NOT move however.  So I am now trying the "copy objects"
wizard which apparently allows you to copy the whole shebang.  It appears to
be working, though the speed is not so wonderful.  This is a smallish table,
~6 million records, ~15 fields, each having an index.

Should be interesting to see how long it takes.

But thanks for mentioning this, it will make my job easier if I can master
this.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Doris
Manning
Sent: Friday, November 03, 2006 5:37 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Any gut feelings?

John,

Can I claim this one too?  

<snip>Next YouDaMan prize goes to the one who provides the syntax to
transfer an entire table - structure, data and indexes intact, from one db
to another. That ought to slow you folks down! <snip>

Check out Data Transformation Service (DTS) in Enterprise Manager.  There is
a wizard that walks you through it.  You set up the from connection (server
and database) and to connection (server and database).  You pick the objects
you want to transfer and off they go.

Doris Manning
Hargrove Inc. 


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com