I have seen a lot of resources online about something similar to my issue but nothing came to concrete help (content is old or not quite relevant) so I appreciate some help.
used SP designer 2013 to develop webpart site page
Defined datasource to SQl server database connection
Inserted dataview to the page based on SQL datasource
Now I want to move the page from dev to prod. I created the datasources on prod same as DEV
When I took the code of the pages on DEV and used on PRod , I had this error
Web Part Error: An error has occurred. Correlation ID: 9baf979c-1607-3081-07b4-a7577a8956bd.
Searching showed that this is expected because the webpart config is stored in content database and some Guids are involved here. I read somewhere that I can change the guid to name for DataFormWebPart but that keyword doesn't even exist in the code (must be for legacy version)
So , how can , easily, move sitepage between sites on different servers? I do not want to redevelop things from scratch.