Copying and pasting data to or from UltraLite databases

With Sybase Central you can copy and paste as well as 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.

Target Result
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.
Note

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.

Sybase Central

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:

Interactive SQL

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