Technical Question
in [Programming SQL]
|
Prev: MS SQL Reporting Services Request.QueryString Problem
Next: need a sql FUNCTION to show subscript with integer
From: Uri Dimant on 15 Feb 2010 04:05 pers Yes SSIS would be good way. Have you investigated also replication? "pers" <rezarms(a)hotmail.com> wrote in message news:eUP63zhrKHA.4752(a)TK2MSFTNGP04.phx.gbl... >I want to integrate them immediately. > SSIS is a good way? > "pers" <rezarms(a)hotmail.com> wrote in message > news:elYKOjhrKHA.4220(a)TK2MSFTNGP05.phx.gbl... >> SqlServer 2005 >> "Uri Dimant" <urid(a)iscar.co.il> wrote in message >> news:OpYDaihrKHA.728(a)TK2MSFTNGP04.phx.gbl... >>> pers >>> What is the vesrion of SQL Server are you using? >>> >>> "pers" <rezarms(a)hotmail.com> wrote in message >>> news:ugfM8bhrKHA.3408(a)TK2MSFTNGP06.phx.gbl... >>>> Hi all >>>> I have a main server with some agents which each agent acts like a >>>> server. >>>> in each agent SqlServer is installed. >>>> How can I integrate all agents's data into main server. >>>> I know a solution is to merge them. >>>> Is there a better way to merge them ?? >>>> thanks in advance >>>> >>>> >>> >>> >>> >> >> >> > >
From: pers on 15 Feb 2010 04:11 No,I haven't. I want these seperate databases get latest data from main server or send data to main server to update imediately. "Uri Dimant" <urid(a)iscar.co.il> wrote in message news:u4R0u3hrKHA.5940(a)TK2MSFTNGP02.phx.gbl... > pers > Yes SSIS would be good way. Have you investigated also replication? > > > "pers" <rezarms(a)hotmail.com> wrote in message > news:eUP63zhrKHA.4752(a)TK2MSFTNGP04.phx.gbl... >>I want to integrate them immediately. >> SSIS is a good way? >> "pers" <rezarms(a)hotmail.com> wrote in message >> news:elYKOjhrKHA.4220(a)TK2MSFTNGP05.phx.gbl... >>> SqlServer 2005 >>> "Uri Dimant" <urid(a)iscar.co.il> wrote in message >>> news:OpYDaihrKHA.728(a)TK2MSFTNGP04.phx.gbl... >>>> pers >>>> What is the vesrion of SQL Server are you using? >>>> >>>> "pers" <rezarms(a)hotmail.com> wrote in message >>>> news:ugfM8bhrKHA.3408(a)TK2MSFTNGP06.phx.gbl... >>>>> Hi all >>>>> I have a main server with some agents which each agent acts like a >>>>> server. >>>>> in each agent SqlServer is installed. >>>>> How can I integrate all agents's data into main server. >>>>> I know a solution is to merge them. >>>>> Is there a better way to merge them ?? >>>>> thanks in advance >>>>> >>>>> >>>> >>>> >>>> >>> >>> >>> >> >> > > >
From: Erland Sommarskog on 15 Feb 2010 11:51 pers (rezarms(a)hotmail.com) writes: > No,I haven't. > I want these seperate databases get latest data from main server or send > data to main server to update imediately. Sounds like it's Merge Replication you are looking for, but the information you have given is so scant it is impossible to tell. Merge Replication is not exactly trivial, as far as I understand. (Never tried it myself). You need to add to GUID columns to the tables to replicate. Then again, to be able to successfully implement something like you describe, you need to have a clear understanding how you want to handle update conflicts. That is, what if the same row was updated in all databases independently, which update should win? Once you have a full understanding of this, there are several options to consider: o Merge Replication. o SSIS packages. o Custom-written stored procedures/application code. o Ditto, built on Change Tracking, a feature added in SQL 2008. If you able to post a more detailed description of what you want to achieve, it would be a good thing to cross-post for forums for replication and Integration Services, so experts in those fields can add their ideas. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
From: pers on 16 Feb 2010 01:30
in agents when users enter data I want some of conditions like accounting is processed in main server. I mean every agent is not independent.in some situation those need to connect to main server to get last update then check condition. "Erland Sommarskog" <esquel(a)sommarskog.se> wrote in message news:Xns9D20B5A514E56Yazorman(a)127.0.0.1... > pers (rezarms(a)hotmail.com) writes: >> No,I haven't. >> I want these seperate databases get latest data from main server or >> send >> data to main server to update imediately. > > Sounds like it's Merge Replication you are looking for, but the > information > you have given is so scant it is impossible to tell. > > Merge Replication is not exactly trivial, as far as I understand. (Never > tried it myself). You need to add to GUID columns to the tables to > replicate. > > Then again, to be able to successfully implement something like you > describe, you need to have a clear understanding how you want to handle > update conflicts. That is, what if the same row was updated in all > databases > independently, which update should win? > > Once you have a full understanding of this, there are several options to > consider: > o Merge Replication. > o SSIS packages. > o Custom-written stored procedures/application code. > o Ditto, built on Change Tracking, a feature added in SQL 2008. > > If you able to post a more detailed description of what you want to > achieve, > it would be a good thing to cross-post for forums for replication and > Integration Services, so experts in those fields can add their ideas. > > -- > Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se > > Links for SQL Server Books Online: > SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx > SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx > SQL 2000: > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx > > |