Order By Setting
- This setting affects Comparison, Migration, Synchronization and scripting
processes.
- Batch processes are affected as well.
- Be sure that Order By settings are identical for two tables used in
Comparison and Synchronization.
- Misleading in Order of two tables in compared databases may cause
inappropriate results, long process time and odd result analysis trouble.
- It's recommended to use these options, only if your table has no Indexes.
For single column
- Right click column name and use Order By this column.
Icon near the column name will be changed.
For all columns in specific table/view
Right-click table/view name and use Order by all columns .