SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 Not successful transferring user-defined functions
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

maranbe
Starting Member

Philippines
28 Posts

Posted - 08/22/2006 :  05:29:09  Show Profile
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

Sweden
30250 Posts

Posted - 08/22/2006 :  05:36:35  Show Profile  Visit SwePeso's Homepage
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

Philippines
28 Posts

Posted - 08/22/2006 :  22:58:00  Show Profile
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

Philippines
28 Posts

Posted - 01/24/2007 :  21:35:49  Show Profile
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

USA
5072 Posts

Posted - 01/24/2007 :  23:36:55  Show Profile  Visit russell's Homepage
much easier to backup/restore if migrating from sql2000 ---> sql20005
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000