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.
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 LarssonHelsingborg, Sweden |
|
|
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... |
|
|
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. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-01-24 : 23:36:55
|
much easier to backup/restore if migrating from sql2000 ---> sql20005 |
|
|
|
|
|
|
|