SQLCLR to SQL-Server 2005
-
Hi all,
My manager came to me and said that i need to migrate SQLCLR to SQLServer2005
i googled it and learned abt SQLCLR but want to know abt migraton stratergies involved
pls tell me
1) what r the steps involved in doin the migration.
2) do i need to convert all .NET code to YSQL? (any other method)
3) factors i need to consider
4) any simple links will be suffice
Cheers
Danny
-
What kind of CLR stuff do you have? Just asking in general about migrating it's a pretty vague question.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
u mean C# or vb.net?
i know SQLCLR means all written in .NET code and compiled as dll etc
-
You need to give more information here. A lot more.
What's your manager talking about migrating?
SQL CLR is the CLR (the common language runtime) within SQL Server (2005+). It allows procedures, functions, triggers to be written in one of the CLR languages (and there are a lot of them, VB and C# are just the best known)
Since you don't know what SQLCLR is, can I assume you have no existing CLR objects? If that's the case, what are you migrating from what, to what and why?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
presumably you have access to the source for the CLR functions you are to migrate?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply