Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 Not successful transferring user-defined functions

Author  Topic 

maranbe
Starting Member

28 Posts

Posted - 2006-08-22 : 05:29:09
Hi Folks,

I am trying to copy all user-defined functions in my old SQL Server 2000 to SQL Server 2005 via Transfer SQL Server Objects Task but it seems none have been copied. Please help. Thanks.

Object property for CopyAllUserDefinedFunctions is set to "True".

Debug log:
SSIS package "copy user-defined functions.dtsx" starting.
Information: 0x4002F418 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Logins to transfer.
Information: 0x4002F41D at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Users to transfer.
Information: 0x4002F362 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Rules to transfer.
Information: 0x4002F366 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Tables to transfer.
Information: 0x4002F370 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Views to transfer.
Information: 0x4002F358 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Stored Procedures to transfer.
Information: 0x4002F378 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Defaults to transfer.
Information: 0x4002F382 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no User Defined Data Types to transfer.
Information: 0x4002F386 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Partition Functions to transfer.
Information: 0x4002F390 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Partition Schemes to transfer.
Information: 0x4002F394 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Schemas to transfer.
Information: 0x4002F398 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no SqlAssemblys to transfer.
Information: 0x4002F402 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no User Defined Aggregates to transfer.
Information: 0x4002F406 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no User Defined Types to transfer.
Information: 0x4002F410 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no XmlSchemaCollections to transfer.
SSIS package "copy user-defined functions.dtsx" finished: Success.

Kindest regard,

SQL Server 2K (Clustered)/2K5
_________________________
if ain't broke, don't fix it...

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-22 : 05:36:35
Try and refresh the SSMS window with F5 button.
All seems to have transferred the way you wanted. No objects other than User Defined Functions seems to have been transferred as CopyAllUserDefinedFunctions setting.

Peter Larsson
Helsingborg, Sweden
Go to Top of Page

maranbe
Starting Member

28 Posts

Posted - 2006-08-22 : 22:58:00
Hi Peter,

done that for several times and even restarted the mssms. is it because the functions were created from sql server 2k?

Kindest regard,

SQL Server 2K (Clustered)/2K5
_________________________
if ain't broke, don't fix it...
Go to Top of Page

maranbe
Starting Member

28 Posts

Posted - 2007-01-24 : 21:35:49
Found out that stored procedures and functions were copied during the database migration from 2000 to 2005 although incomplete...need to investigate further...

Kindest regard,

SQL Server 2K (Clustered)/2K5
_________________________
Our life is frittered away by detail ... Simplify, simplify.
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2007-01-24 : 23:36:55
much easier to backup/restore if migrating from sql2000 ---> sql20005
Go to Top of Page
   

- Advertisement -