[thelist] SQL DTS Transfer

[Ben Dyer]

D'oh!  I just saw it, too.  If it was a snake it woulda bit me.

Thanks, Dex.  You the man on this kind of stuff.

--Ben

<tip type="SQL" author="Ben Dyer">
If you know anything about T-SQL, you probably know of INNER JOIN and OUTER 
JOIN.  But don't forget about their rarely-used cousin CROSS JOIN which 
will select every matching combination between two tables.

When is this useful?  A school system is a good example.  If you have a 
table of students and a table of dates, you can use a CROSS JOIN to select 
every matching combination of students and dates to generate attendance 
records.

Caveat: This is over-generalized, the code can get very hairy for something 
like this.  It's just good to be aware of the little-used SQL commands 
because you never know when they might come in handy.
</tip>

At 01:24 PM 8/29/2001, you wrote:
>If you are going between SQL servers, then do the Xfer objects between
>SQL Servers option --you'll have much more control over the
>operation....
>
>sgd
>
> > -----Original Message-----
> > From: Ben Dyer [mailto:ben_dyer at imaginuity.com]
>
> > "Include extended properties" under "Copy objects and data
> > between SQL
> > Server Databases", but the help file makes it sound like that
> > isn't it.
> >

<!-----------------------
Ben Dyer
Senior Internet Developer
Imaginuity Interactive
http://www.imaginuity.com
//---------------------->