The Data Editor allows you to view and quickly edit data right in the grid. For more information on editing data refer to topic Editing Data in Grid.
Use the rich set of data management options in the shortcut menu.
If you want to retrieve all 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
- turn on Paginal Mode.
To simplify data analysis, you can use the following features:
By default, Paginal Mode is enabled in data view with 1000 records per page, so only 1000 records are displayed at once. For more information, see Paginal Mode.
In Data Compare for SQL Server, you can customize the data grid according to your needs:
Grid rows’ background and foreground colors can also be set. You can set them separately for odd and even rows, focused row, selected rows, focused cell, group rows.
Data row can be viewed, edited and printed as cards. To learn more about it, consult the Card View topic.
Data Compare for SQL Server allows you to view data as text. To retrieve data as text click Results as text under the SQL menu, switch to the Data tab in the Output window and execute the query to get data. You cannot edit data in the Output window.
Null values 0000-00-00 in fields of DATE data type are displayed as 01.01.0001. Null values of TIMESTAMP fields are displayed as 01.01.0001 0:00:00.