Copying SQL statements

You can copy SQL statements from one data project to another data project.

You can copy SQL statements by using Copy and Paste commands on pop-up menus. You can also copy SQL statements within data development projects by dragging them.

Restriction: When you copy SQL statements, the source and target data projects must be the same type. That is, you can copy SQL statements from one data development project to another data development project. Or you can copy SQL statements from one data design project to another data design project. However, you cannot copy SQL statements from a data development project to a data design project, or vice versa.

To copy SQL statements:

  1. In the Data Project Explorer view, expand the source data project, and then expand the SQL Scripts folder.
  2. Expand the target data project.
  3. Select one or more SQL statements in the source data project. Use the Ctrl or Shift key to select multiple statements.
  4. Do one of the following actions:
    • Right-click the selected SQL statements and click Copy on the shortcut menu. Right-click the SQL Scripts folder in the target data project, and then click Paste on the pop-up menu.
    • (Data development project only) Drag the selected SQL statements to the SQL Scripts folder in the target data development project.
If the target data project contains an SQL statement that has the same name as a copied SQL statement:

Feedback