About data pipelines
The Data Pipeline painter gives you the ability to reproduce data
quickly within a database, across databases, or even across DBMSs. To do
that, you create a data pipeline which, when executed, pipes the data as
specified in the definition of the data pipeline.
What you can do
With the Data Pipeline painter, you can perform some tasks that
would otherwise be very time consuming. For example, you can:
-
Pipe data (and extended attributes) from one or more tables to
a table in the same DBMS or a different DBMS -
Pipe an entire database, a table at a time, to another DBMS
(and if needed, pipe the database’s extended attribute system
tables) -
Create a table with the same design as an existing table but
with no data -
Pipe corporate data from a database server to a SQL Anywhere
database on your computer so you can work on the data and report on
it without needing access to the network -
Upload local data that changes daily to a corporate
database -
Create a new table when a change (such as allowing or
disallowing NULLs or changing primary key or index assignments) is
disallowed in the Database painter
Piping data in applications
You can also create applications that pipe data. For more
information, see Piping Data Between Data Sources in Application Techniques.
Source and destination
databases
You can use the Data Pipeline painter to pipe data from one or
more tables in a source database to one table in a destination
database.
You can pipe all data or selected data in one or more tables. For
example, you can pipe a few columns of data from one table or data
selected from a multitable join. You can also pipe from a view or a
stored procedure result set to a table.
When you pipe data, the data in the source database remains in the
source database and is reproduced in a new or existing table in the
destination database.
Although the source and destination can be the same database, they
are usually different ones, and they can even have different DBMSs. For
example, you can pipe data from an Adaptive Server Enterprise database
to a SQL Anywhere database on your computer.