May 03, 2018 07:06 PM|RuthlessRoth|LINK
I am moving the data from one SQL server 2015 to 2012. Made a new table in 2012 with a different name and exported the data.
I had to manually set the IDnum to increment by 1 and set the primary key.
Those setting did not come over when I exported the data from one server to the other.
On the 2015 server I used export and change the destination tables name to a new one
I changed the SQL connection to the new server in the web page..
List page lists our vendors and contact information. Simple grid with delete and edit functions
I can successfully add a new vendor to the list using the Add page. A separate pagfe for adding vendors.
I can delete the vendor from the table using the delete button in the grid of the listing page.
But I can not edit it. It opens the edit grid and appears to do everything correct but the database entry does not get changed.
I am using a IDnum field type int and is the primary key for the table. Wondering if there is a setting for the new table I missed that was on the old table in 2005 SQL