2 Replies - 746 Views - Last Post: 30 October 2012 - 05:21 AM Rate Topic: -----

#1 seemajoshi  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 09-October 12

remote connection

Posted 29 October 2012 - 01:43 AM

string cmdText = "insert into member(name,email,fname,DobDay,DOBMONTH,DOBYEAR,GENDER,MaritalStatus,Subsection,Gothra,BirthStar,Rashi,Qualification,Professional,Income,nobrother,noofsis,paddress,ppincode,laddress,lpincode,noofbmarried,noofbumarried,noofsmarried,noofsumarried,mobilephno,stdcode,Requirement,height)select name,email,fname,DobDay,DOBMONTH,DOBYEAR,GENDER,MaritalStatus,Subsection,Gothra,BirthStar,Rashi,Qualification,Professional,Income,nobrother,noofsis,paddress,ppincode,laddress,lpincode,noofbmarried,noofbumarried,noofsmarried,noofsumarried,mobilephno,stdcode,Requirement,height from 'remote _ip'.remote_db.member";




PLEASE TELL ME IF THIS CODE WILL COPY THE TABLE FROM LOCAL TO REMOTE DATABASE
member is the table present in both databases with same structure.

Is This A Good Question/Topic? 0
  • +

Replies To: remote connection

#2 seemajoshi  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 09-October 12

Re: remote connection

Posted 29 October 2012 - 01:52 AM

string cmdText = "insert into member(name,email,fname,DobDay,DOBMONTH,DOBYEAR,GENDER,MaritalStatus,Subsection,Gothra,BirthStar,Rashi,Qualification,Professional,Income,nobrother,noofsis,paddress,ppincode,laddress,lpincode,noofbmarried,noofbumarried,noofsmarried,noofsumarried,mobilephno,stdcode,Requirement,height)select name,email,fname,DobDay,DOBMONTH,DOBYEAR,GENDER,MaritalStatus,Subsection,Gothra,BirthStar,Rashi,Qualification,Professional,Income,nobrother,noofsis,paddress,ppincode,laddress,lpincode,noofbmarried,noofbumarried,noofsmarried,noofsumarried,mobilephno,stdcode,Requirement,height from '66.147.244.205'.hermunde_sync.member";

PLEASE TELL ME IF THIS CODE WILL COPY THE TABLE FROM LOCAL TO REMOTE DATABASE
member is the table present in both databases with same structure.
Was This Post Helpful? 0
  • +
  • -

#3 h4nnib4l  Icon User is offline

  • The Noid
  • member icon

Reputation: 1182
  • View blog
  • Posts: 1,677
  • Joined: 24-August 11

Re: remote connection

Posted 30 October 2012 - 05:21 AM

We heard you the first time. Why don't you try running it yourself to see what happens?
Was This Post Helpful? 1
  • +
  • -

Page 1 of 1