MS SQL
MS SQL
Background
The web site PeacePays.org (which won't work for you) uses a Flash front end (support ceased 01/01/2021), has a MS SQL database back end and is hosted on an expensive web hosting provider. It would be nice to re-create the site using some supported technical solution and with updated content. My task:
- get the content out into human-readable form;
- try to create a working copy of the site for reference;
- remove the site from its current hosting company.
The developers of the web browser Pale Moon are committed to continuing to provide Flash functionality, despite Adobe removing support for Flash. This runs under Linux and Windows and provides a way to run the Flash content on the site. Getting Pale Moon working under Linux gave its own challenges.
Having copied the files from the PeacePays,org web site to a PC, I can disconnect the PC from the Internet and run the Flash part of the site in Pale Moon, but it requires the MS SQL database to work. So I need to:
- install MS SQL on the PC, in particular MS SQL Server
- transfer the database to the PC
- see if I can edit the Flash code to point to the new database location.
I am committed to Linux partly on principle and partly because I only have Windows 7. MS SQL will run on older versions of Linux but not Windows 7.
I looked at converting the database from MS SQL to something Linux compatible such as MySQL, but since I am unfamiliar with the content and structure of the database, I cannot predict what problems the compatibility changes will cause.
There is a free version of MS SQL for Linux.
Installing MS SQL in Linux
I am running Xubuntu 18.04.5