sql server dts: SQL DTS 2005 to 2000 -- sql server dts

SQL DTS 2005 to 2000

xiaomei
1/11/2007 11:15:03 PM

sql server dts:

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

Re: SQL DTS 2005 to 2000

Allan Mitchell
1/13/2007 10:13:54 AM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.