.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Asad Ali
Post New Web Links

Transfer data from MOSS to WSS

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :SharePoint
 

I am trying to design a solution for a company to publish various information through a SharePoint interface to their site offices.

Main office: MOSS 2007 or 2010
Site Offices: WSS or 2010 Foundation

Site offices are connected to the main office via a satelilte link which charges on amount transferred (data exchange needs to be kept to the minimum possible)

Objects published are mainly documents and maybe some lists.

The idea is that when something changes/gets published somewhere in the MOSS server then this information gets sync'd in all site offices.

Any ideas greatly appreciated

Thanks!




View Complete Post


More Related Resource Links

Using Conditional Split data Transfer in SSIS 2008

  
This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

Cutting Edge: Pros and Cons of Data Transfer Objects

  

After a brief refresher on procedural and object based patterns for organizing the business logic layer, the author focuses on data transfer objects and the impact they have on the development of the software project.

Dino Esposito

MSDN Magazine August 2009


Marshalling Your Data: Efficient Data Transfer Techniques Using COM and Windows 2000

  

The way you choose to transfer data is vitally important in a distributed application. Windows 2000 provides several new features that allow you to transfer data more efficiently. Lightweight handlers allow you to write smart proxies that can cache results and perform buffered reads and writes, minimizing the number of network calls. Windows 2000 also allows you to use pipe interfaces to transfer large amounts of data efficiently through a read-ahead facility. This article illustrates several ways to improve data transfer in Windows 2000 using these new features. It also reports the results of transfer time tests and provides recommendations for transferred buffer sizes.

Richard Grimes

MSDN Magazine September 2000


Configurable SSIS data transfer package

  
I have to create SSIS Pakage for importing data form a sql server to  another. And this SSIS data transfer package has to be configurable at run time for: - Database source connection - Database destination connection - Query to call from the source database - Table to insert in destination database And Also need to call this package from a stored procedure...

Data list with page transfer

  
I built a data list list in the follow. It seems that href is not asp language. How can I transfer it to asp language? <ItemTemplate>  <a href="~/Team.aspx?Id=<%#Eval("TeamId")%>"> <%#Eval("TeamName") %> </a>  </ItemTemplate>

how to transfer data from list column to another column of the same list programmatically?

  
I have a list and i want to transfer the data from column "Test Display Name" to "Test Display Name Dummy" at renamed it back to "Test Display Name" however i'm getting problem transferring the data. pls help. thanks actually the root problem is my list is not exporting to spreadsheet. i'm getting an error "An operation that uses the database driver could not be completed If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query. For other drivers, contact your database administrator or driver vendor." any idea how can i export this Private Sub UpdateTestName() Using oSite As SPSite = New SPSite("http://test_baseline:13838/") Using oWeb As SPWeb = oSite.OpenWeb("SharedArea") Try Dim oList As SPList = oSite.RootWeb.GetList("/SharedArea/Lists/Test Names") oList.Fields.Add("Test Display Name Dummy", SPFieldType.Text, True) oList.Update() For Each oListItem As SPListItem In oList.Items If oListItem.Fields.ContainsField("Test Display Name") Then oListItem("Test Display Name Dummy") = oListItem("Test Display Na

Can not transfer data usisng SSIS

  
Database Server is SQL2008 with SP1. I created ODBC that connects to one table in the database in the server. It works fine. Then I created a SSIS package that tranfer this table's data into another table using the ODBC. When executing the SSIS , it works fine. No problem transfering data using ODBC via SSIS. Requirement is to use SSIS package in SQL Server job and run it from there. When the SQL job is run , it fails.  Error thrown is Message Executed as user: CORE\svc_prodsql1. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.2531.0 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  12:42:08 PM  Error: 2010-08-26 12:42:08.39     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2010-08-26 12:42:08.75     Code: 0xC0047062     Source: Data Flow Task ADO NET Source [16]     Description: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft]

automatic transfer data from one table to another table in mysql.

  
Hi all,         i done one web application in this application i need to transfer the data from one table to another automatically when the time is 10.00PM. i need to write this function sepearte time function not in page load function.the user select any of page the data should be transfer from one to another without page load only using time control function.. if anybody know this ,please reply me.Thank You,Arunabathan.G

Excel data to MOSS custom list

  
Hi, My requirement is that I have some excel sheets on server and i want to import those data into MOSS2007 site custom list. what is the best approach to achieve this?

Hi.How I can to transfer data from object to parameter?

  
Hi to All. I have class with object wich populated with data from Users Interface  now I need to transfer the data to Store Procedure SQL but i can to transfer the data only using Parameters how I can to get the data from object and to put it in @parameter? Thanks/

data transfer between 2 web applications

  
how can data be transfered between 2 web applications runnig on 2 web servers 

Data Flow Tasks does not complete even though data transfer has ended

  
I have an SSIS 2008 package which contains a number of SQL Tasks and Data Flow tasks with precedence.  When I run each of the tasks separately, the transfer is completed, and sometimes the data flow task turns green, but sometimes it does not.  When I run the package as a whole from my workstation, a few of the tasks compete but then all processing stops.  There are no errors, the package just sits there.  The objects within the Data Flow tasks are green and the data transfer is completed, but the task is yellow and the package does not move on to the next task. Each of the Data Flow tasks consists of one ADO.Net Source to an ODBC driver for Cache and an OLDB Destination to a SQL Server database.  I can monitor the source connections and I can see when the successful transfer activity stops.  However, the package does not close the connection and move on to the next task. I have tried different levels of precedence and even allow all of the tasks to run in parallel and it does not seem to matter.

Using WCF unable to transfer bulk data in windows base application

  
Hi, I am testing bulk data transfer over WCF service and my project structure is as follows. Project Structure: 1> One Console application that have the WCF service reside of it. 2> One Class library that contain the interface and a class file that implement the interface. 3> Another Windows Application type project act as a client interface that call the service using proxy. Now the scenario I have is as follows: 1> Inside of the console application their is a module that have the (following server side code) .This service is hosted in the Console app programmatically (No config file). Server Code: Dim x As New NetTcpBinding(SecurityMode.None)         With x             .TransactionFlow = False             .TransferMode = TransferMode.Streamed             .MaxReceivedMessageSize = Integer.MaxValue             .CloseTimeout = New TimeSpan(0, 10000, 0)             .OpenTimeout = New TimeSpan(0, 10000, 0)             .ReceiveTimeout = New TimeSpan(0, 10000, 0)       &n

MOSS 2007 : Data store missing in the middle of process

  
Dear Expert, My user always report that some data that have been key-in by them (sharepoint web form) was missing during the WF is routing to (verifier & approval). FYI the verifier & approval only have a permission as a "View" anybody here have a same experience with me?? Isit the issue is because of sharepoint itself or human (i've try to create dummy record but work fine) ??

WCF to transfer data to client applications

  

Hi,

I want to create a  WCF Service to transfer data to our clients application(WPF).

The Data I am trying to send is as follows.

ID  Code          Description   unit    Rate

1   104200000   LIVE GOAT      NOS     25

2   104200000   LIVE GOAT2    NOS    25

3   104200030   LIVE GOAT3    KGS     10

4   104202030   Water             LTR      5

and so on till ~ 11000 records.

What I have done so far is. Created a service which return a list of data.

-----------

 public List<Classes.TariffData> GetTariffData()
 {
  var currentTariffData = new List<Classes.TariffData>();

  using (var myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
  {
  const string query = "select a.ID,a.Code,a.Description,a.unit,a.rate,a.rate3 from tariff.dbo.tariffdata a, tariff.dbo.code_history b where a.id = b.id and b.endofvalidity is null";
  using (var myCommand = new SqlCommand(query, myConnec

Data Transfer in C# slow when targeting SQL Server 2005 using SQL Server SMO version 10 (distributed

  

 

Hello everyone,

I have a strange issue regarding SQL Server SMO Transfer. I am using the Transfer class to create a copy of a database. I will explain the different cases I have tried so far and maybe someone can help me figure out what's going on.

First case

I run my C# code from an assembly that references version 9.0.242.0 of SMO assemblies that are in my GAC

  • Microsoft.SqlServer.ConnectionInfo
  • Microsoft.SqlServer.Smo
  • Microsoft.SqlServer.SqlEnum

If I target a database hosted on a Sql Server 2005 database engine, it works perfectly and fast.

But of course, as soon as I try to target a Sql Server 2008 database engine, it complains that it is not compatible. No surprise there.

 

Second case

I run the exact same C# code from an assembly that references version 10.0.0.0 of SMO assemblies that are also present in my GAC

  • Microsoft.SqlServer.ConnectionInfo
  • Microsoft.SqlServer.Management.Sdk.Sfc
  • Microsoft.SqlServer.Smo
  • Microsoft.SqlServer.Smo.Extended
  • Microsoft.SqlServer.SqlEnum

If I target a database hosted on a Sql Server 2008 database engine, it works perfectly and fast.

However, if I try to target the sam

Data Transfer in C# slow when targeting SQL Server 2005 using SQL Server SMO version 10 (distributed

  

 

Hello everyone,

I have a strange issue regarding SQL Server SMO Transfer. I am using the Transfer class to create a copy of a database. I will explain the different cases I have tried so far and maybe someone can help me figure out what's going on.

First case

I run my C# code from an assembly that references version 9.0.242.0 of SMO assemblies that are in my GAC

  • Microsoft.SqlServer.ConnectionInfo
  • Microsoft.SqlServer.Smo
  • Microsoft.SqlServer.SqlEnum

If I target a database hosted on a Sql Server 2005 database engine, it works perfectly and fast.

But of course, as soon as I try to target a Sql Server 2008 database engine, it complains that it is not compatible. No surprise there.

 

Second case

I run the exact same C# code from an assembly that references version 10.0.0.0 of SMO assemblies that are also present in my GAC

  • Microsoft.SqlServer.ConnectionInfo
  • Microsoft.SqlServer.Management.Sdk.Sfc
  • Microsoft.SqlServer.Smo
  • Microsoft.SqlServer.Smo.Extended
  • Microsoft.SqlServer.SqlEnum

If I target a database hosted on a Sql Server 2008 database engine, it works perfectly and fast.

However, if I try to target the sam

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend