Data base development system with methods facilitating copying of data from one data source to another
First Claim
1. A method for copying data from one data source to another, the method comprising:
- selecting source and destination database profiles for source and destination data sources, respectively, each profile comprising sufficient information for supporting a connection to a respective one of the source and destination data sources;
establishing a connection to said source and destination data sources;
displaying a graphical user interface for graphically defining a pipeline object, said pipeline object specifying particular data to copy from the source data source to the destination data source;
saving said pipeline object to a storage device, so that it can be executed upon invocation; and
copying data from the source data to the destination data by executing said pipeline object;
wherein displaying a graphical user interface step includes;
receiving user input for graphically creating a SQL SELECT statement which specifies the data to be copied from the source data to the destination data.
1 Assignment
0 Petitions
Accused Products
Abstract
A Client/Server Database System with improved methods for performing database queries, particularly DSS-type queries, is described. The system includes one or more Clients (e.g., Terminals or PCs) connected via a Network to a Server. In general operation, Clients store data in and retrieve data from one or more database tables resident on the Server by submitting SQL commands, some of which specify "queries"--criteria for selecting particular records of a table. The system implements a "Data Pipeline" feature for programming replication of data from one database to another in client applications. Specifically, a pipeline object and SQL SELECT statement are built using a Pipeline Painter. The Data Pipeline lets a user (developer) easily move data from a high-end database server (e.g., Sybase) to a local database (Watcom SQL), all without the user having to issue SQL commands. The pipeline object facilitates moving data from one database management system to another, or between databases of the same type.
-
Citations
9 Claims
-
1. A method for copying data from one data source to another, the method comprising:
-
selecting source and destination database profiles for source and destination data sources, respectively, each profile comprising sufficient information for supporting a connection to a respective one of the source and destination data sources; establishing a connection to said source and destination data sources; displaying a graphical user interface for graphically defining a pipeline object, said pipeline object specifying particular data to copy from the source data source to the destination data source; saving said pipeline object to a storage device, so that it can be executed upon invocation; and copying data from the source data to the destination data by executing said pipeline object; wherein displaying a graphical user interface step includes; receiving user input for graphically creating a SQL SELECT statement which specifies the data to be copied from the source data to the destination data. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
Specification