Migrating from MY SQL to MS SQL

dusty_nz

Joined: 2009-04-28
Posts: 5
Posted: Tue, 2009-04-28 23:22

I am just in the process of upgrading my Gallery installation and also in moving from a linux to windows install.

Has anyone worked with a SQL script that would allow me to migrate my images etc from the My SQL database to MS SQL?

If I was to do it then what tables would I need to move across?

Working with Gallery2

Thanks
 
mridgwel

Joined: 2007-01-27
Posts: 215
Posted: Wed, 2009-04-29 23:30

I have - see:

http://gallery.menalto.com/node/87195

Assuming you've used default the prefix g2_ on the tables then its all the tables with g2_.

Don't do the upgrade and the migration in the same step - that's a recipe for disaster. Do one and then the other once you're happy with the status of the first operation.

_________
Mark
ACCU - www.accu.org - Professionalism in Programming.