selecting values from one database and inserting to another database

Discussion in 'C#' started by ravisakee, Dec 10, 2008.

0
  1. #1
    Hi ,
    I am new to asp ,i migrated from asp.net to asp recently ....
    i want to select vales from one database and insert it into another database...
    can i use sqldatareader in asp??? or any other option??
    please help me out...
    Thanks
    Ravi
     
    ravisakee, Dec 10, 2008 IP
  2. develop008

    develop008 Member

    Messages:
    65
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #2
    Please do a search in google for data migrators. Or you can write script to do it. What database you are using?

    www.rosepark.co.in
     
    develop008, Dec 11, 2008 IP
  3. camjohnson95

    camjohnson95 Active Member

    Messages:
    737
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    60
    #3
    why would u migrate from asp.net to asp?
     
    camjohnson95, Dec 11, 2008 IP
  4. freelancerguy

    freelancerguy Banned

    Messages:
    102
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Instead of sqldatareader you can use sqlbulkcopy.
     
    freelancerguy, Dec 11, 2008 IP
  5. vihutuo

    vihutuo Well-Known Member

    Messages:
    1,511
    Likes Received:
    34
    Best Answers:
    0
    Trophy Points:
    180
    #5
    I think you meant to say you are migrating from "asp to asp.net" ...
    Why are you migrating the database because of the language change?. ASP.NET can work with almost all databases that asp worked with
     
    vihutuo, Dec 12, 2008 IP
  6. hajan

    hajan Peon

    Messages:
    22
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Above all... ASP.NET is one of the most secure web scripting language coz it uses a whole programming language behind the page. Classic ASP is very bad and I simply don't like it.. but ASP.NET is my favourite!
     
    hajan, Dec 16, 2008 IP
  7. mpatel

    mpatel Peon

    Messages:
    26
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    it may help you ,it is directly inserting data ifrom one table to another.
    create proc latestnews
    (
    insert into Topnews(Title,News,Keywords,imageid)select Title,News,Keywords,imageid from Technews where ID=(select max(id) from Technews)
    insert into Topnews(Title,News,Keywords,imageid)select Title,News,Keywords,imageid from sportsnews where ID=(select max(id) from sportsnews)
    insert into Topnews(Title,News,Keywords,imageid)select Title,News,Keywords,imageid from business where

    )
    You can do it by progaramming try..
     
    mpatel, Dec 24, 2008 IP