May 2, 2016 at 2:56 am
Hi Guys,
I am currently doing a specification for a migration project where I will be moving a load of SQL Server objects from SQL Server 2008 to SQL Server 2012 on a different server. I am not moving a full database and therefore won't be doing a backup/restore, I will be scripting out certain objects to be moved.
There is a CLR function that will need to be migrated as part of the project, this is something I do not have any experience with and my .NET programming skills are beginner at best. Apart from enabling CLR functionality on the new server, moving the dll file and scripting out the assembly, is there anything else that needs to be done?
The guy who did the work no longer works for the company.
The permission property on the assembly is set to SAFE
May 2, 2016 at 4:25 am
Permissions. The CLR objects have permissions like others, so check those.
I'd be sure you have the correct source code, and if not, start tracking that down in case you need it.
May 2, 2016 at 4:49 am
Hi Steve
Excellent points... thank you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply