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 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.