I did a test import on localhost of a small backup copy of the database. Impex didn't report any errors and all is fine except the post counts were not filled in, and I know the post counts are in the source database (I peeked at both db's using phpMyadmin to confirm this).
My question is, is it possible, with the sourceuserid still intact, to add the post counts via a custom query, if it's done right after the import? Or is that too complex to be realistic? If it is possible, could someone provide a guess to get me started?
Note: I fully admit I probably have created this problem myself.. I didn't have access to a MSSQL server. So I "cheated" by using MySQL Migration Toolkit to take Webwiz Access .mbd file directly to MySQL format. So probably in some small way the MySQL file created isn't exactly what Impex script expects.
But this is SO close to being perfect.. I'm hoping I don't have to scrap everything and go looking for a temporary hosting co. with MSSQL and MySQL on same server. a) I don't know anything about MSSQL and b) I already have two managed servers, but can't get MSSQL put on either one.
Any suggestions appreciated.
My question is, is it possible, with the sourceuserid still intact, to add the post counts via a custom query, if it's done right after the import? Or is that too complex to be realistic? If it is possible, could someone provide a guess to get me started?
Note: I fully admit I probably have created this problem myself.. I didn't have access to a MSSQL server. So I "cheated" by using MySQL Migration Toolkit to take Webwiz Access .mbd file directly to MySQL format. So probably in some small way the MySQL file created isn't exactly what Impex script expects.
But this is SO close to being perfect.. I'm hoping I don't have to scrap everything and go looking for a temporary hosting co. with MSSQL and MySQL on same server. a) I don't know anything about MSSQL and b) I already have two managed servers, but can't get MSSQL put on either one.
Any suggestions appreciated.
Comment