Copying SQL statements
You can copy SQL statements from one data project to another data project.
About this task
You can copy SQL statements by using Copy and Paste commands on pop-up menus.
Restriction: For products that
support more than one type of data project, 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.
Procedure
To copy SQL statements:
- In the Data Project Explorer view, expand the source data project, and then expand the SQL Scripts folder.
- Expand the target data project.
- Select one or more SQL statements in the source data project. Use the Ctrl or Shift key to select multiple statements.
- 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.