The Data Editor of Data Compare for SQL Server lets you view, edit, and print data in the Card View mode, where each data row (record) is represented as a card with a ‘Record N’ caption and number.
To enable the Card View mode, click the Switch to Card View button on the Data Editor toolbar. To return to the Grid View mode, click the Switch to Grid View button on the Data Editor toolbar.
You can view or edit data in the same way as in the Grid View. Data cards can be expanded and collapsed with the corresponding button in the upper right corner of the card.
As opposed to the vertical scrolling of the Grid View, the Card View features horizontal scrolling.
There are two patterns for the results output: the Paginal mode and the Infinite scrolling.
The paginal mode splits data into pages and is used to display data with a large number of records.
Note
By default, the paginal mode displays 1000 records per page. You can set the Paginal mode by default and specify any preferred number of records to be displayed per page on the Tools menu > Options > Data Editor > General.
If you disable the paginal mode, the Infinite scrolling pattern will be activated, which loads data continuously as the user scrolls down the page and allows retrieving all data at once.
Note
If you want to retrieve all data from a table with a large number of records, you will get a message warning you about the possibility of the Out of memory exception. You can choose to continue retrieving data, to cancel retrieving data, or to turn on the paginal mode.
You can use a rich set of data management options from the shortcut menu.
Note
Use the Set Value To menu to quickly set an empty string, zero, or the current date.
To refresh data, select Refresh in the Data menu (for the data view), from the shortcut menu, or on the toolbar. To abort an overly long refresh operation, select Stop Refresh in the Data menu (for the data view) or on the toolbar.
You can sort cards by column. To do that, go to the required column and use the sorting glyph to select the Ascending or Descending order.
To clear sorting on the current column, select Clear Sorting from the shortcut menu.
You can print data by right-clicking a card and selecting Print from the shortcut menu. Alternatively, press CTRL+P. The Preview window opens.
The Preview window allows to preview and adjust cards before printing. You can view thumbnails for each page, search for required data, customize printing options, open/save printing documents in the .prnx format, conduct page setup (format, width, height, orientation, and margins), add header and footer, zoom in and out, and quickly navigate across pages.
Print options can be configured in the Tools menu > Options > Data Editor > Print. Alternatively, select Options from the shortcut menu.
You can adjust the width and height of the cards. For this, in the Card View, click Customize.
Next, in the Layout View Customization dialog that opens, select the card and then drag its bottom-right corner to change its size.
You can view and edit data in the built-in Data Viewer. To open it, right-click the required cell in the grid and select Data Viewer. Alternatively, use the CTRL+W, R key combination. In the Data Viewer, you can save data to a file, copy/paste or cut data, view data in multiple formats, as well as make white spaces visible.
When dbForge Data Compare executes a statement, the retrieved data is displayed in the same SQL document in Data Editor.
The Data Viewer toolbar has the following options:
Refresh Data and Stop Refresh Data allow you to refresh data and stop refreshing it in the grid, respectively.
Cached Updates Mode, Apply Changes, and Cancel Changes
Cached Updates Mode lets you control data editing within a single database object. If you turn on this mode for an object, your changes will be stored locally on the client side until you click Apply Changes. If you want to discard the changes, click Cancel Changes. If you close a document in the Cached Updates Mode, you will cancel all the changes made since the latest Apply Changes command.
Paginal Mode allows switching to the paginal mode.
Go to First Page / Go to Previous Page /Go to Next Page/ Go to Last Page allow switching between pages and specify the number of records per page.
Switch to Grid View and Switch to Card View allow switching between the result grid views.
Show Group by Box displays the group data by the current column.
Customize allows customizing the column display in cards. In the LayoutView Customization window that opens, you can drag the elements from the Hidden Items section to the Template Card and then preview the changes on the View Layout tab. In addition, the View Layout tab allows sorting or filtering data in the card mode by clicking the corresponding options next to the specific column. To save the changes, click OK. To apply the changes immediately, click Apply. To discard the changes, click Cancel.
The bottom panel of the grid has the following options:
let you navigate down the grid one record at a time, or instantly get to the first or the last record in the grid.
allow you to append or delete records from the grid.
let you apply or cancel changes made during editing.
In the grid, you can copy or edit the selected data. To select multiple cards, do one of the following actions:
Using the CTRL key can help you include/exclude cards from selection.
Note
Some queries return read-only data, for example, queries with aggregate functions (count, avg etc.), or data, retrieved from non-updatable views. Such data cannot be edited. It is also impossible to edit the result of executing of the script with several select statements.
You can copy selected data by selecting Copy or Copy With Headers from the shortcut menu.
Alternatively, you can copy selected data using shortcuts:
Use CTRL+C to copy data.
Use CTRL+SHIFT+C to copy data with headers.
Additionally, you can select Copy Data As from the shortcut menu to Copy Column Names Only or Copy Column Names and Types.
Similarly, you can paste data by selecting Paste or Paste As New Records from the shortcut menu or using the CTRL+V shortcut.
For these operations, you can use the shortcut menu or the corresponding buttons under the cards. For example, you can do the following:
Note
Use the Set Value To menu to quickly set an empty string, zero, or the current date.
To add a new record, select the Append option from the shortcut menu or click the + button under the cards.
To delete a record from the card, select the Delete option from the shortcut menu or click the - button under the cards. You can also use the CTRL+DEL key combination.
Note
Some queries return read-only data; for example, queries with aggregate functions (e.g. COUNT, AVG) or data, retrieved from non-updatable views. Such data cannot be edited. It is also impossible to edit the results of multiple SELECT statements.
When working with the cards, you can see special indicators next to the focused cell. These indicators reflect the current editing state.
The row is focused.
The row is being edited.
The row has been edited.
An invalid value has been entered into a cell. You must either enter a valid value or press the ESCAPE key to cancel changes.