Deploy New User Defined Function to Anon Merge Replicas

How do I get a New UDF to propagate to Anonymous Merge Subscribers?
SS2K SP4 Added New UDF <fctrptTeamReview> to Database using Wizard
Tried CREATE in Query Analyzer, then though there might be a Stored
Procedure . . . No joy! Checked BOL, Hilary & Paul
Aubrey Kelley
your options are
1) create a new publication and send it
2) use sp_addscriptexec to deploy it to unc deployed subcribers only (it
doesn't work for ftp)
3) use ado to send it there
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Aubrey" <miscuates@.online.nospam> wrote in message
news:0DEF03C0-7DC1-46D2-B13E-9D58B65E1C27@.microsoft.com...
> How do I get a New UDF to propagate to Anonymous Merge Subscribers?
> SS2K SP4 Added New UDF <fctrptTeamReview> to Database using Wizard
> Tried CREATE in Query Analyzer, then though there might be a Stored
> Procedure . . . No joy! Checked BOL, Hilary & Paul
> --
> Aubrey Kelley
|||Thanks, Hilary!
Tried: sp_addscriptexec Database, "fullpathname\TeamReview.sql"
Subscriber Initialized OK, and got this far:
Launching osql to apply script 'TeamReview.sql'
After a few seconds it Errored Out with:
The schema script '0\\servername\ReplData\2005112082642800\TeamRevie w.sql'
could not be propagated to the subscriber.
Why is it prepending the '0' (Zero) to the Path? How can I remedy this?
Of course this had broken Merge Replication, and I cannot get rid of it!
Aubrey Kelley
"Hilary Cotter" wrote:

> your options are
> 1) create a new publication and send it
> 2) use sp_addscriptexec to deploy it to unc deployed subcribers only (it
> doesn't work for ftp)
> 3) use ado to send it there
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Aubrey" <miscuates@.online.nospam> wrote in message
> news:0DEF03C0-7DC1-46D2-B13E-9D58B65E1C27@.microsoft.com...
>
>
|||Hello Aubrey,
It seems the configuration of the replication has some issues. Does the
issue occur if you create a new publicaiton with this shared snapshot
location? Also, you may want to try a different shared folder for snapshot
to test the situation.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Deploy New User Defined Function to Anon Merge Replicas
| thread-index: AcXt20NbtIQ7JH6qSzyDPoJAnLeSBQ==
| X-WBNR-Posting-Host: 69.218.133.236
| From: =?Utf-8?B?QXVicmV5?= <miscuates@.online.nospam>
| References: <0DEF03C0-7DC1-46D2-B13E-9D58B65E1C27@.microsoft.com>
<unfOv7c7FHA.3048@.TK2MSFTNGP10.phx.gbl>
| Subject: Re: Deploy New User Defined Function to Anon Merge Replicas
| Date: Sun, 20 Nov 2005 06:04:03 -0800
| Lines: 49
| Message-ID: <5B5E6958-5768-4782-A676-8ED3880BC45C@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.replication
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.replication:66799
| X-Tomcat-NG: microsoft.public.sqlserver.replication
|
| Thanks, Hilary!
|
| Tried: sp_addscriptexec Database, "fullpathname\TeamReview.sql"
|
| Subscriber Initialized OK, and got this far:
| Launching osql to apply script 'TeamReview.sql'
|
| After a few seconds it Errored Out with:
| The schema script
'0\\servername\ReplData\2005112082642800\TeamRevie w.sql'
| could not be propagated to the subscriber.
|
| Why is it prepending the '0' (Zero) to the Path? How can I remedy this?
|
| Of course this had broken Merge Replication, and I cannot get rid of it!
| --
| Aubrey Kelley
|
|
| "Hilary Cotter" wrote:
|
| > your options are
| >
| > 1) create a new publication and send it
| > 2) use sp_addscriptexec to deploy it to unc deployed subcribers only
(it
| > doesn't work for ftp)
| > 3) use ado to send it there
| >
| >
| > --
| > Hilary Cotter
| > Looking for a SQL Server replication book?
| > http://www.nwsu.com/0974973602.html
| >
| > Looking for a FAQ on Indexing Services/SQL FTS
| > http://www.indexserverfaq.com
| >
| > "Aubrey" <miscuates@.online.nospam> wrote in message
| > news:0DEF03C0-7DC1-46D2-B13E-9D58B65E1C27@.microsoft.com...
| > > How do I get a New UDF to propagate to Anonymous Merge Subscribers?
| > >
| > > SS2K SP4 Added New UDF <fctrptTeamReview> to Database using Wizard
| > >
| > > Tried CREATE in Query Analyzer, then though there might be a Stored
| > > Procedure . . . No joy! Checked BOL, Hilary & Paul
| > > --
| > > Aubrey Kelley
| >
| >
| >
|
|||FYI: Further experience with Error:
The schema script
'0\\servername\ReplData\2005112082642800\TeamRevie w.sql' could not be
propagated to the subscriber.
The prepended '0' (Zero) on the Path aborted Anonymous Merge Replication
over the Internet (HTTP).
On a virgin Win XP Pro / SP2 (immediately after re-imaging from Compaq
Recovery CD's), loaded with my MS Access SQL Runtime Project. The Merge
Replication is coded in Forms based VB Modules. The Merge.Initialize worked
just fine (as always). Then 'osql' attempted to run the schema script, and
Failed!
Just for fun, I opened a VPN to the Host, tested it with Windows Explorer
(to \\hostservername) and with a VB File Copy Command Button on my
Synchronize Form. This time, the Merge worked just fine!
Conclusion: the Schema Script File needs the VPN (or LAN) to support its
File Copy.
Great learning (on Turkey Day (USA)).
Aubrey
Aubrey Kelley
"Hilary Cotter" wrote:

> your options are
> 1) create a new publication and send it
> 2) use sp_addscriptexec to deploy it to unc deployed subcribers only (it
> doesn't work for ftp)
> 3) use ado to send it there
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Aubrey" <miscuates@.online.nospam> wrote in message
> news:0DEF03C0-7DC1-46D2-B13E-9D58B65E1C27@.microsoft.com...
>
>

Deploy .NET Assembly with UDFs to a particular SCHEMA

Is it possible to deploy .NET assemblies and the UDF functions therein from Visual Studio.NET into a particular schema?Unfortunately this is not possible through Visual Studio 2005. You would need to write your own script for doing this.
However, you can execute any SQL script during the post deploy process in your SQL Server project as:

1. Write your script into a file called postdeployscript.sql:

2. Add the file to your project by right clicking your project in Solution Explorer and Add à Existing Item.

Make sure you add this in the root of the project and not in the Test Scripts. When you click deploy, Visual Studio will automatically run this scripts after the deployment of your project.
Same holds for predeployscript.sql if you want to execute a script on the SQL server before deployment.

These scripts can be used to automate something that Visual Studio does not currently support.

Thanks,
-Vineet.

|||

postdeployscript.sql and predeployscript.sql are the things I dreamed about all the time . You should definitely include them into default template of SQL Server Project, because I was searching for this solution for two months until I found this post. I asked similar question on the TechNet and the answer was just "you cannot do it".

Deploy .NET Assembly with UDFs to a particular SCHEMA

Is it possible to deploy .NET assemblies and the UDF functions therein from Visual Studio.NET into a particular schema?Unfortunately this is not possible through Visual Studio 2005. You would need to write your own script for doing this.
However, you can execute any SQL script during the post deploy process in your SQL Server project as:

1. Write your script into a file called postdeployscript.sql:

2. Add the file to your project by right clicking your project in Solution Explorer and Add à Existing Item.

Make sure you add this in the root of the project and not in the Test Scripts. When you click deploy, Visual Studio will automatically run this scripts after the deployment of your project.
Same holds for predeployscript.sql if you want to execute a script on the SQL server before deployment.

These scripts can be used to automate something that Visual Studio does not currently support.

Thanks,
-Vineet.

|||

postdeployscript.sql and predeployscript.sql are the things I dreamed about all the time . You should definitely include them into default template of SQL Server Project, because I was searching for this solution for two months until I found this post. I asked similar question on the TechNet and the answer was just "you cannot do it".