Re: SQL DTS 2005 to 2000
- From: "Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx>
- Date: Sat, 13 Jan 2007 16:39:36 +0000
Hi
The URL is for books online that comes with SQL Server 2005. Sorry for the confusion. You can find the "online" version here
http://msdn2.microsoft.com/en-us/library/ms142159.aspx
--
Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com
"xiaomei" <xiaomei@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:CFA8C098-6159-496C-89E7-D9A788BB3331@xxxxxxxxxxxxx:
Hi, Allan,
Thank you very much for the advice gaven. However the I could not open the
url, Kindly resend, thanks.
Best regards
SHERMAINE
"Allan Mitchell" wrote:
> This is not something new. DTS using the Data Pump steps will only move
> structure and data. It did this in 7 and 2000 only. To move objects
> other than that as well you may want to look at using
>
> 1. The transfer objects task.
> (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/fe86d6e5-e415-406c-88f3-dc3ef71bd5f0.htm)
> 2. Scripting
>
>
>
> --
>
>
> Allan Mitchell
> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
> http://www.konesans.com
>
>
>
>
> "xiaomei" <xiaomei@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:2E639311-95C3-492E-8E4F-5AE0A9A6F75B@xxxxxxxxxxxxx:
>
> > Hi, There,
> > Because the SQL does not support down grade, so I was trying to get my
> > database from 2005 to 2000 by using DTS, however, after I finish the
> > transfer, I find only data was transfered, all index and stored process not
> > coming, is there any other way to save my situation?
> >
> > Thanks and regards
> > Shermaine
>
>
.
- Prev by Date: Re: Unable to delete a package
- Next by Date: Execute SQL Task
- Previous by thread: Re: SQL DTS 2005 to 2000
- Next by thread: Re: Unable to delete a package
- Index(es):
Relevant Pages
|
