March 17, 2012 at 5:18 am
scenario is almost like microsoft's codeplex example..
Adventure Works Cycles is a bicycle manufacturer that sells bicycles to retail bicycle shops throughout the United States and Canada.
Adventure Works Cycles bicycles are sold direct to customers from their Web site and are purchased by the retail shops and resold at a markup; retail accounts are serviced by a nationwide sales force of Adventure Works Cycles sales professionals.
This sales force is organized into sales territories, which are managed by Territory Sales Managers, who in turn report to the Vice President of Sales.
Although all sales account data is maintained by the Adventure Works Cycles corporate office in Bothell, Washington, in a SQL Server database, individual salespersons are responsible for maintaining the sales-related data for their own accounts, including customer information and all sales and returns.
Salespeople also must have access to the latest product-related data, including pricing, up-to-date inventory information, and individual historical sales data.
Where requirement is like :
1] Can we create subscription using a script (C# script).
2] Client server synchronization should be on demand using script with region filter in the script itself.
Out of this I am trying to create a powershell script for create subscription.
then we can call this powershell file through C#. I don't know anything in C#.
Sagar Sonawane
** Every DBA has his day!!:cool:
March 17, 2012 at 7:48 am
Create and sync subscriber using SQL server powershell script.
is anyone have the script??
Sagar Sonawane
** Every DBA has his day!!:cool:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply