Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

transfer data in sql server using visual basic 2008

vb.net sql server adodb visual basic 2008

  • Please log in to reply
1 reply to this topic

#1 faeza

faeza

    CC Lurker

  • Just Joined
  • Pip
  • 1 posts
  • Programming Language:(Visual) Basic
  • Learning:(Visual) Basic

Posted 04 September 2012 - 05:47 PM

Hello..I have a question..I want to do programming about transfer data in sql server from database A to database B & the database automaticly always transfer data to database B if have a new data in database A using application visual basic 2008 & library ADODB..anyone can help me??..please..
  • 0

#2 lespauled

lespauled

    CC Leader

  • Expert Member
  • PipPipPipPipPipPipPip
  • 1360 posts
  • Programming Language:C, C++, C#, JavaScript, PL/SQL, Delphi/Object Pascal, Visual Basic .NET, Pascal, Transact-SQL, Bash

Posted 05 September 2012 - 04:58 AM

It seems fairly straightforward:

1. connect to each db. (source and dest connections)
2. Get Table data from source
3. Update the destination table where the values are different.

Why not create a job on the database?
  • 0
My Blog: http://forum.codecal...699-blog-77241/
"Women and Music: I'm always amazed by other people's choices." - David Lee Roth





Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download