How to deploy assemblies to SQL Server 2005

I'm investigating the possible problems of transition of my project to
SQL Server 2005.
I'm planning to intensively use the CLR integration as it gives a lot
of benefits.
Here is the problem: to deploy the compiled CLR assembly to SQL Server
I have to put it on the shared location that is visible from the SQL
Server 2005 side, and then run "CREATE ASSEMBLY..." statement.
The question is: In general I won't have such a "shared location" as
the SQL server may be "on the other side of planet", I mean it may not
have access to the shared folders the client may access. My program
will be distributed all over the world, it should work in different
environments, so I cannot rely on the shared location. Is there any
other method to deploy the assembly to SQL Server? This is the only
true problem as far as I can see that stops me from starting the
transition.Please use the SQL Server 2005 newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Sergei Almazov" <almazik@.ukr.net> wrote in message
news:1105634014.804208.150320@.c13g2000cwb.googlegroups.com...
> I'm investigating the possible problems of transition of my project to
> SQL Server 2005.
> I'm planning to intensively use the CLR integration as it gives a lot
> of benefits.
> Here is the problem: to deploy the compiled CLR assembly to SQL Server
> I have to put it on the shared location that is visible from the SQL
> Server 2005 side, and then run "CREATE ASSEMBLY..." statement.
> The question is: In general I won't have such a "shared location" as
> the SQL server may be "on the other side of planet", I mean it may not
> have access to the shared folders the client may access. My program
> will be distributed all over the world, it should work in different
> environments, so I cannot rely on the shared location. Is there any
> other method to deploy the assembly to SQL Server? This is the only
> true problem as far as I can see that stops me from starting the
> transition.
>