Using C# to copy data from one database backend to another


  • I am new to C# and I am trying to write an application that will copy data from one database and create a new table and insert the data into this new table.

    The SQL statement I want to use is something like "Create Table Blah as Select * from OtherTable" or Select * into Blah from OtherTable"

    I am dealing with 2 different database programs.  I want to retrieve the results of a query another database program (Teradata) and copy it directly into SQL Server and create the table on the fly.

    I am assuming that using a SqlDataAdapter would be the best way.  The data that I will be pulling from Teradata is a static so I could use a SqlDataReader if that would work better.

    Does anyone have any suggestions?


    Thursday, December 21, 2006 6:25 PM


All replies