exception of type 'system.outofmemoryexception' was thrown Aras innovator

Root cause: Your AML might returning more data
Solution:
-change AML query, try to avoid select="*", give always select="id,item_number"

Visual Studio compare SQL server table Data Compare

Visual Studio => Tools => SQL Server => New Data Comparison ...
In the new window, Under "Source Database", Click on "Select Connection..."
Enter SQL DB Server name
Select Database
Click on Connect

In the new window, Under "Target Database", Click on "Select Connection..."
Enter SQL DB Server name
Select Database
Click on Connect

Check All check boxes

Click Next

Select Tables which you want to compare
Finish
You will see data difference b/w 2 DBs

Visual Studio - How to Compare Database Schema

Open Visual studio
Tools-->SQL Server-->New Schema Comparison..
You will see a page, where you can select source database using option "Select Source..."
New window will open -->Select "Database"
Click on Select Connection..
Enter Server: SQLLocalhost
Enter Authentication, user name, password
Select "Database Name" Ex: DB1
Click Ok

In the Visual studio page, select target database using option "Select Target..."
New window will open -->Select "Database"
Click on Select Connection..
Enter Server: SQLLocalhost
Enter Authentication, user name, password
Select "Database Name" Ex: DB2
Click Ok

Click on "Compare"