Sql Server Data Insert Gurunchi Doubt ?

[BenzCircle]

[quote name='qualityposter1' timestamp='1355948158' post='1302982357']
em conditions unnay
[/quote]

[deals2buy]

[quote name='qualityposter1' timestamp='1355948158' post='1302982357']
em conditions unnay
[/quote]
conditions ento kuda cheppu...

[gundugadu]

[quote name='littlemoon' timestamp='1355946846' post='1302982022']
we have 2 servers
suppose name as

server 1: database name- A and

server 2 : database name -B

konni reasons valla same data ni 2 servers lo maintain chesthuanmu...

some connection problem vachi few days nunchi server 2 lo ne data update avthundi now we want to insert all that into server 1 as well..

idhi condition

server 1 A DB lo oka SP undi which checks the conditions to get some data from 2 different tables and inserts into 1 table XX lo ki which is in server 1 itself

server 2 B DB lo unna data ni server 1 table XX lo ki insert cheyali executing the stored procedure(so tht conditions chk avali)


alredy linked server chesanu but next em cheyalo ardham kavtledhu... simple insert chdam ante conditions unayi...

server 1 lo SP exec chesthu server 2 data ni ela insert cheyachu ?

cursors anevii emaina use cheyacha ?


[/quote]

baaaa ippudu neee problem
yela cheyali ana yela chesthe baguntundi anaaaaaaa

NUvvu eppudu server 1 lo ye data miss ayyindo aaa data mathram load cheyali andunnav kada
I thisnk sql thone cheyavachu

mundu neevvu server 1 lo missing ayinda data ni anthatini oka temp table loki load ayyela chesuko

then do simple insert from the temp table to server 1.



let me know for any questions.

[littlemoon]

[quote name='Kaarthikeya' timestamp='1355948142' post='1302982352']
nee SQL Server version ento cheppu...

if it is 2005 and above let me know..
[/quote]
2008 r2 using ...


conditions person record preferences ni chk chesthamu.. like email subscribed .. weekly a daily aa ala so vatti values ni chk cheyali insert chese mundu

[mtkr]

server 2 ni source laga teesuko
n follow same procedure tht inserts data into server 1 tables....
n use lookup for updates

[deals2buy]

[quote name='littlemoon' timestamp='1355949388' post='1302982609']
2008 r2 using ...


conditions person record preferences ni chk chesthamu.. like email subscribed .. weekly a daily aa ala so vatti values ni chk cheyali insert chese mundu
[/quote]
ok..and u want to do only the missing data?

[littlemoon]

[quote name='gundugadu' timestamp='1355948429' post='1302982421']
baaaa ippudu neee problem
yela cheyali ana yela chesthe baguntundi anaaaaaaa

NUvvu eppudu server 1 lo ye data miss ayyindo aaa data mathram load cheyali andunnav kada
I thisnk sql thone cheyavachu

mundu neevvu server 1 lo missing ayinda data ni anthatini oka temp table loki load ayyela chesuko

then do simple insert from the temp table to server 1.



let me know for any questions.
[/quote]yela cheyali anesi ??

[littlemoon]

[quote name='Kaarthikeya' timestamp='1355949450' post='1302982622']
ok..and u want to do only the missing data?
[/quote]
ya just miss ayana rows ni insert cheyali

[ChampakDas]

flat procedure rasi...oke proc lo two servers ni access chesi rachu kada...unless you are completely aware the corresponding columns...
ssrs use cheyi best..

[Desamudhuru]

adi ni SP ela rasi vundi dani batti... Connections oka sari check cheyu.

[littlemoon]

[quote name='mtkr' timestamp='1355949414' post='1302982613']
server 2 ni source laga teesuko
n follow same procedure tht inserts data into server 1 tables....
n use lookup for updates
[/quote]
koncham clear ga explain cheshtara naku ardham kaledhu

server 1 lo sp use chesi update cheshtunamu so server 2 ni source laga
ante sp lo source server 2 name petti antunara?

[littlemoon]

[quote name='GatisKandis' timestamp='1355949593' post='1302982642']
flat procedure rasi...oke proc lo two servers ni access chesi rachu kada...unless you are completely aware the corresponding columns...
ssrs use cheyi best..
[/quote]
no ssrs ssis

[deals2buy]

[quote name='Desamudhuru' timestamp='1355949603' post='1302982644']
adi ni SP ela rasi vundi dani batti... Connections oka sari check cheyu.
[/quote]Agreed
[quote name='littlemoon' timestamp='1355949558' post='1302982638']
ya just miss ayana rows ni insert cheyali
[/quote]
if possible SP sample PM chey
[quote name='GatisKandis' timestamp='1355949593' post='1302982642']
flat procedure rasi...oke proc lo two servers ni access chesi rachu kada...unless you are completely aware the corresponding columns...
ssrs use cheyi best..
[/quote]
SSRS kaadu mitram SSIS anukunta nuvvu cheppedi?

[deals2buy]

[quote name='littlemoon' timestamp='1355949747' post='1302982667']
koncham clear ga explain cheshtara naku ardham kaledhu

server 1 lo sp use chesi update cheshtunamu so server 2 ni source laga
ante sp lo source server 2 name petti antunara?
[/quote]
ya adi try cheyyochu...since u already created linked server for that

[Calm Guy]

server 1 lo insert ayinappudu already conditions check ayyuntundi kada...
as u mentioned, both the servers should have same data...right? if so, insert those records missing in server 2 from server 1...