Yes. But we do not recommend it because it can slow down the performance
Specify the server_name\instance_name e.g. PEARL\SQLEXPRESS
To add port number: PEARL\SQLEXPRESS,4444
IP address with the port number: 127.0.0.1,4444 or 127.0.0.1\SQLEXPRESS,4444
No. The product is available without any restrictions for 14 days
No. Only user tables and views found in the system databases can be compared and synchronized
Yes. Use the CSV data export command
Yes. Specify the same database as both source and destination
Yes. Make sure that the columns are mapped properly and that the right Comparison key exists
Yes. Check the Include transaction handling option
Set ApexSQL Data Diff to split the synchronization script into N rows (where N is a customizable value)
Yes. Use Encoding option in the Save as dialog to change the encoding
db_owner for the destination database and db_datareader for the source database
No. However we recommend splitting the comparison into smaller sub-projects for huge databases