The Data Viewer of Data Compare for SQL Server lets you view and edit data directly in the grid, just like in an Excel spreadsheet.
To retrieve data, do any of the following steps:
Note
If you want to retrieve all the data from a table with a large number of records, a message warning you about the possibility of the Out of memory exception is shown, and you can choose either of the following actions - continue retrieving data, cancel retrieving data, or enable the paginal mode. By default, the paginal mode is enabled in data view with 1000 records per page so that only 1000 records are displayed at once. For more information, see Paginal mode.
To change the column order and width, as well as group them by order, drag column headers to the required place. In addition, you can use a rich set of data management options from the shortcut menu.
Right-click the column header and select the required option:
Data rows can be viewed, edited and printed as cards. For more information, see View and edit data in the Card View mode.
To refresh data, select Refresh on the Data menu (for the data view), on the shortcut menu, or on the toolbar. To abort an overly long refresh operation, select Stop Refresh on the Data menu (for the data view) or on the toolbar.
In case the query text has been edited, and changes have been applied, to get updated data, run the Execute command anew instead of refreshing the grid.
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.
The Data Viewer toolbar has the following controls:
Save Data (Ctrl+S) allows saving data to a file.
Copy (Ctrl+C) allows copying data to the clipboard.
The following controls allow viewing data in multiple formats:
Hexadecimal View (Ctrl+1)
Text View (Ctrl+2)
XML View (Ctrl+3)
HTML View (Ctrl+4)
Web View (Ctrl+5)
Rich Text View (Ctrl+6)
PDF View (Ctrl+7)
JSON View (Ctrl+8)
Image View (Ctrl+9)
Spatial View - Geometry (Ctrl+Alt+0)
View White Space makes white spaces visible.
Word Wrap adjusts the display of long text within cells or columns. When it is activated, the text automatically wraps onto the next line, making all the content visible within the cell’s width.
When dbForge Event Profiler executes a statement, the retrieved data is displayed in the same SQL document in Data Editor.
The Data Editor 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 allows you to apply data updates in a single batch, thus emulating a separate transaction. If this mode is activated, your data changes will be stored locally on the client side until you click Apply Changes. If there is no need for the changes to be applied, click Cancel Changes. If you close a document with Cached Updates Mode activated, all the changes made since the latest Apply Changes command will be canceled.
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.
Auto-search mode turns on the auto-search mode.
The bottom panel of the grid has the following options:
: These controls let you navigate down the grid one record at a time, or instantly get to the first or the last record in the grid.
: These controls allow you to append or delete records from the grid.
: These controls let you apply or cancel changes made during editing.
To select data, do one of the following actions:
Using the CTRL key can help you include/exclude cells from selection. Any number of rows may be copied and pasted to another application (for example, a spreadsheet). However, when you paste data in the data grid, only the first row will be pasted.
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.
To copy the selected data, right-click it and do the following:
To paste data, select Paste or Paste As New Records on the shortcut menu or press CTRL+V.
For these operations, you can use the shortcut menu or the corresponding options under the grid. 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 Append on the shortcut menu or click + under the grid.
To delete a record from the grid, select Delete on the shortcut menu or click - under the grid. Alternatively, press CTRL+DEL.
When working with the grid, 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.