fetch data from one database to other

Page 1 of 1

5 Replies - 942 Views - Last Post: 07 August 2012 - 04:39 AM Rate Topic: -----

#1 kai_itz me  Icon User is offline

  • D.I.C Head

Reputation: 18
  • View blog
  • Posts: 138
  • Joined: 03-August 12

fetch data from one database to other

Posted 06 August 2012 - 04:57 AM

hi,

im using vb.net for designing and sql server as database.

i have created two form in vb and for both of them i have created different database.
in database1 i have make the entry of 50 person and database2 is empty right now.
in db1 there are 5 columns in db2 i have created 10.
now i want to fetch the data in db1 to db2,,,,
for this i want to know what are the condition to fetch data from db1 to db2. is it possible ?
what should i use to do so join or something else,,, i just need hint

Is This A Good Question/Topic? 0
  • +

Replies To: fetch data from one database to other

#2 DarenR  Icon User is offline

  • D.I.C Lover

Reputation: 200
  • View blog
  • Posts: 1,523
  • Joined: 12-January 10

Re: fetch data from one database to other

Posted 06 August 2012 - 05:20 AM

I have almost no idea what your are asking....place the code you have so far so we can better understand your question. use [code] tags.


also If i undertsand you correctly you want to take info from table a and put it in table b? yes this is possible
Was This Post Helpful? 0
  • +
  • -

#3 JackOfAllTrades  Icon User is offline

  • Saucy!
  • member icon

Reputation: 5667
  • View blog
  • Posts: 22,509
  • Joined: 23-August 08

Re: fetch data from one database to other

Posted 06 August 2012 - 09:34 AM

Moved to VB.NET
Was This Post Helpful? 0
  • +
  • -

#4 m_wylie85  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 93
  • View blog
  • Posts: 871
  • Joined: 15-October 10

Re: fetch data from one database to other

Posted 06 August 2012 - 10:45 AM

Are these two separate databases or as DarenR said are there just two tables?

e.g Person Table and Empty Table all in the one database

also if these are two different databases is there a reason why you don't want to use one database with 2 tables?.
Was This Post Helpful? 0
  • +
  • -

#5 kai_itz me  Icon User is offline

  • D.I.C Head

Reputation: 18
  • View blog
  • Posts: 138
  • Joined: 03-August 12

Re: fetch data from one database to other

Posted 06 August 2012 - 10:28 PM

actually i am talking about two different database,,,
Was This Post Helpful? 0
  • +
  • -

#6 e_i_pi  Icon User is offline

  • = -1
  • member icon

Reputation: 745
  • View blog
  • Posts: 1,521
  • Joined: 30-January 09

Re: fetch data from one database to other

Posted 07 August 2012 - 04:39 AM

Should be possible to do this with a single SQL query, unless the two databases are on different servers. Even still, it is possible to do cross-server queries with MSSQL. What are the schemas of the two tables?
Was This Post Helpful? 1
  • +
  • -
Page 1 of 1