May 22, 2019, 8:14 a.m. sql-server , docker , northwind , linux
Right-O Jeeves, I downloaded the Northwind backup for sql server, but how do I restore it with sqlcmd? RESTORE DATABASE Northwind FROM DISK='/tmp/Northwind.bak' But that produced Msg 3201, Level 16, State 2, Server 61ea3d23c7fb, Line 1 Cannot open backup device '/tmp/Northwind.bak'. Op ...Dec. 22, 2016, 8:37 a.m. odo , python , django , sqlite , mysql
In theory if you use django, changing your RDBS from say sqlite to mysql is a breeze. All you need is generate a dump of your existing data with ./manage.py dumpdata, change settings.py and do ./manage.py migrate on the new server. Then you can import the previously exported data through ./manage.py ...