Sql Server Data Insert Gurunchi Doubt ?

[littlemoon]

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 ?

[minnu]

[littlemoon]

[quote name='minnu' timestamp='1355946983' post='1302982054']

[/quote]

[bokuboy]

[bokuboy]

[quote name='littlemoon' timestamp='1355947048' post='1302982071']


[/quote]

[img]http://www.desigifs.com/sites/default/files/Genni-2.gif?1337103287[/img]

[Ranga_The_Donga]

SP ne endhuku use cheyali... pkg lo chesukovachuga...?

[mtkr]

INSERT anagaane my frst fluke ans...... SSIS tho cheyyocha???!!!!


Q manchiga chadivi aalochinchuthaa...

[mtkr]

[quote name='Jeedeelu' timestamp='1355947187' post='1302982109']
SP ne endhuku use cheyali... pkg lo chesukovachuga...?
[/quote]

[9Pardhu]

simple ga latest bakup of server 2 ni tesi after business hours server 1 meeda restore chesuko vayya..

na SSL problem ki matram evaru reply ivvadamledu

[mtkr]

[quote name='9pardhu' timestamp='1355947299' post='1302982143']
simple ga latest bakup of server 2 ni tesi after business hours server 1 meeda restore chesuko vayya..

na [color=#ff0000][b]SSL [/b][/color]problem ki matram evaru reply ivvadamledu
[/quote]


ekkada post chesinav mama??

[9Pardhu]

[quote name='mtkr' timestamp='1355947711' post='1302982245']
ekkada post chesinav mama??
[/quote]

http://www.andhrafriends.com/topic/368938-ssl-certificates-gurinchi-evarikina-telusa-cer-pfx/

[littlemoon]

SSIS use cheyamu memu

n sp alrdy rasi undhi andulo conditions example person record oka value 0 / 1 ila chk chese conditions and ipudu server 2 nunchi insert chese apudu kuda a values chk cheyali.. if alrd existing em change cheykunda and migitha rows update avali..

9pardhu : ssl enti ?

[mtkr]

[quote name='9pardhu' timestamp='1355947965' post='1302982311']

[url="http://www.andhrafriends.com/topic/368938-ssl-certificates-gurinchi-evarikina-telusa-cer-pfx/"]http://www.andhrafri...telusa-cer-pfx/[/url]
[/quote]
thelisinollu reply icharu ga mama... ltt chesthu unduuuu...ekkado 6th page la undhiii thread...
naak aithe antha arabic maatladuthunnatu undhi anduloo( b/c naak adi thelavad kabatti)

[deals2buy]

nee SQL Server version ento cheppu...

if it is 2005 and above let me know..

[qualityposter1]

[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... [b]simple insert chdam ante conditions unayi...[/b]

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

cursors anevii emaina use cheyacha ?


[/quote]

em conditions unnay