We use the DTS Transfer Database task to blast our live database to a
standby server at regular intervals. The TD task is a monolithic task which
transfers a complete database. Thus, as the database changes its structure,
the TD task continues to work perfectly. It simply transfers the entire
database, including Tables, Views, Sprocs, Triggers, etc.

This task seems to be gone in SQL Server 2005. The nearest thing to this
seems to be the wizard which will generate a series of transfer table tasks.
The drawback to this is that the package generated will only be valid for as
long as the structure of the database remains constant. But what if the
structure changes? We'll add tables and drop tables, not to mention a whole
host of VIEWS, Triggers and Sprocs which simply aren't addressed by this
Wizard. LAME!

Isn't there any way to simply transfer an entire database from one server to
another with SQL Server 2005?

Thanks,

- Joe Geretz -

Which release are you using?

I am looking at the toolbox in Control Flow in the June CTP and can see the
Transfer Database task there.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Joseph Geretz" <jgeretz (AT) nospam (DOT) com> wrote

Hi Alan,

I think I'm using the June CTP. (I'm using the latest which just came with
my MSDN.) How would I verify for certain which CTP I'm using, April or June?

I don't see the Transfer Database task. I imagine it should be sandwiched
between SQL Server Analysis Services Processing Task and Web Services Task
but it's not. Any ideas?

Thanks!

- Joe Geretz -

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Here's my SQL Server version info:

Microsoft SQL Server Management Studio (expires in 365 days)
9.00.1116.00
Microsoft Analysis Services Client Tools 2000.090.1116.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50215.44
Operating System 5.1.2600

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

My version is different

I have 9.00.1187.07



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Joseph Geretz" <jgeretz (AT) nospam (DOT) com> wrote

Where'd you get your version from? I'm using the one that came with my MSDN
Universal June shipment. Did I actually get the April CTP?

Thanks,

- Joe Geretz -

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Mine is the June CTP. I do not have the April CTP available so do not know
if you have that but it would appear that way. Here is a blog post from
Kirk Haselden

"Blogs are probably full of June CTP talk this week, but it's available now
and can be downloaded here:
http://www.microsoft.com/sql/2005/productinfo/ctp.mspx

This was actually an important release for the Integration Services team.

The Migration Wizard has numerous fixes in it to better migrate legacy
packages.

The transfer tasks were finally made available. We're interested in any
feedback you may have on these tasks. They came fairly late in the cycle and
so didn't make it into earlier releases and so consequently haven't had as
much exposure as other features. If you get a chance, please try them out.
Tell us what you think."


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Joseph Geretz" <jgeretz (AT) nospam (DOT) com> wrote