Question Upgrading from 1.7.9 to 2.1.19

My inexperience wit SQL is probably doing me in. So many options . . .

Asked the host to create the SQL back up file into a database and/or move the ft_user tables to the correct database. They don't take responsibility for that kind of work.

So, I have been trying and the options are wild!

I have attached a screen shot of the tool I have available, and one of an sql engine that I think might work IF I have the right commands.

I hate being a pain, but  . .  help!?

To make things more difficult. I was told:

"That's a windows server MySQL backup.

Please ask some professional if you can convert .net to MySQL only."

Would that be one of these?

I'm confused where you're coming from and where you're going. The screenprints are from what? Localhost is your own computer? Then why do you show the Import tab instead of Export?

> That's a windows server MySQL backup

I'm pretty confident the target system is a MySQL database. If you have a MySQL backup, then that should be OK regardless the operating system it runs on. NB: the owner of MySQL is nowadays Oracle.

So I guess your old database was not MySQL but an instance of Microsoft SQL Server (which can run on Linux and has not much to do with dotNet)

What's the exact version of SQL Server you are on? Does that run on your own machine, or on a server somewhere from a hosting company?

The official migration strategy requires you have the MySQL Workbench with the migration wizard installed and running with direct access to the Microsoft SQL Server database. I guess for you that's a difficult route.

What MySQL needs is a SQL script containing statements such as CREATE TABLE and lots of INSERTs. It is possible to create that from Microsoft SQL Server, but the options are overwhelming indeed, and lots can go wrong.

Perhaps due to technical skills & issues the fastest route is to just forget about your old database. I don't know about you, but I have very few active users. Most have not logged in for years and years. Your website is now on a different domain? I'd just send all active users an email with apologies plus a link to the new website and ask them to register / request membership again.