Copying a table

To copy a table from one database server to another:

Create a connection object and establish the connection to the source database.
Create a SELECT command for the connection.
Retrieve the data to be copied.
Create a connection object and establish the connection to for the destination database server.
Create a parameterized INSERT command for bulk insert.
Execute the SQL command to copy the selected data.

This example shows how to copy the data from a table on one database server into a table on another database server.

  {
      TSQLStandardDBProtocolSQLNet15 sqlNet;
      TSQLStandardDataStoreOracle7 oracle7;
      TSQLStandardConnectionHandle dbc(sqlNet, oracle7);

dbc.LogonStep(1, TSQLLogonStep(
          TStandardText("t:129.213.80.90:SAMP"), 
          TStandardText("auser"), TStandardText("apassword")));
      TSQLCommandHandle selectCmd 
          = dbc.CreateSQLCommand(TStandardText(
              "SELECT EMPNO, PROJECTNAME FROM Project")));
  
      selectCmd.Execute();
  
      TRecordSourceHandle recSrc 
          = selectCmd.GetRecordSource();
  
      dbc.LogonStep(1, TSQLLogonStep(TStandardText("other_server"),
          TStandardText("otheruser"), TStandardText("otherpassword")));
  
      TSQLCommandHandle insertCmd =
          dbc.CreateSQLCommand(TStandardText(
              "INSERT INTO Project VALUES(?,?)"));
  
      insertCmd.Execute(recSrc);
  }

[Contents] [Previous] [Next]

Click the icon to mail questions or corrections about this material to Taligent personnel.

Generated with WebMaker