With Sybase Central you can copy and paste and drag and drop. This data transferral allows you to share or move objects among one or more databases. By copying and pasting or dragging and dropping you can share data as described by the table that follows.
|Another UltraLite or SQL Anywhere database.||A new object is created, and the original object's code is copied to the new object.|
|The same UltraLite database.||A copy of the object is created; you must rename the new object.|
You can copy data from a database opened in MobiLink and paste it into an UltraLite database. However, you cannot paste UltraLite data into a database opened in MobiLink.
When you copy any of the following objects in the UltraLite plug-in, the SQL for the object is also copied to the clipboard. You can paste this SQL into other applications, such as Interactive SQL or a text editor. For example, if you copy an index in Sybase Central and paste it into a text editor, the CREATE INDEX statement for that index appears. You can copy the following objects in the UltraLite plug-in:
With Interactive SQL you can also copy data from a result set into another object.
Use the SELECT statement results into a named object.
Use the INSERT statement to insert a row or selection of rows from elsewhere in the database into a table.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|