Enter the key words to find the related topics

Showing posts with label SQL Data base. Show all posts
Showing posts with label SQL Data base. Show all posts

D365 database Sync error convention failed from int to Real

Select the effected table for example salestable, one field in changed from int to real.
After changing the filed we may get an errors  cannot convert from int to Real.

Solution:

Go to Data base execute the below queries.

select * from salestable.// Check the data

select * into salestable_copy from salesTable. // This will copy the data from Salestable to salestable_copy

sp_removable salestable  // this will delete the table from entire data base.

select * into salesTable from salestable_copy  //This will copy the data from salestable_copy to Salestable 

Now we can delete the copy table as shown below.
sp_removable salestable_copy

sp_helptext salesTable // For stored procedure query.