locked
Upload Data Between two different databases RRS feed

  • Question

  • User-1352084188 posted

    Hi, I'm trying to create a new application using a new database which is based on an old database, i need to upload the reords or the data from the old database into the new databases checking for duplication. I should write a routine can som body help me with this please.

    Ta

    Raj

    Wednesday, October 15, 2008 12:51 AM

Answers

All replies

  • User-1384033003 posted

    can u elobarte what exactly u have to do.

    Wednesday, October 15, 2008 2:04 AM
  • User-1327195235 posted

    hi,

    you can use sql select into statement for copying data from one table to another table. to learn more about this go to here http://www.w3schools.com/Sql/sql_select_into.asp

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, October 15, 2008 2:13 AM
  • User-1352084188 posted

    Hi, Guys,

          Thanks a lot. We had an old application to save some test result we are developing a new application using VISUAL STUDIO 2008 and SQL SERVER 2005. We want to upload all the data from the old database into the new database. We have to write a routine to do this as i'm new to SQL just wanted some information on how to go about doing this.

    Ta

    Raj

    Thursday, October 16, 2008 1:15 AM
  • User-821857111 posted

    You could have used Sql Server Migration Assistant to upgrade the database, or export the tables to csv files and use BULK INSERT to get them into SQL Server.

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, October 16, 2008 3:39 AM