I have been sing yaf for a few years now, but after the DNN and YAF upgrades making some of my modules etc fail I figured I would just do a local install and revamp it all. Now thats done I need to migrate all teh YAF data accross from the old database to the new one so I can keep all teh users and posts etc.. however I cant seem to get it runing in SQL server data export/import. I tried a numebr of differant ways but none worked.

I then compared teh two database tables using SQL delta and sure enough there are inconsistancies between the upgraded tables and teh clean install tables.

What I want to know is have any scripts been made which either sort out the tables so that they are teh same so I can export/import the data, or something which can copy teh data accross correctly?

---

You will need to determine what version of YAF the original tables were written in and what version you used with the new tables.

If the old YAF version was v1.9.1.x or older, you have to use a special web.config (included in the newer YAF distributions) and migrate your data using YAF's installer, which will detect the old tables and migrate them. If your version is above 1.9.1.x then you can use the standard web.config included with YAF but you will still need to use YAF's installer to migrate the data and and table/stored procedure inconsistencies.

tha_watcha will be able to shed more light, as he is the DNN module author and will know of any 'special' procedures since you're running under DNN.

---

Sorry I should have said, I have done each yaf upgrade as they came out. So its currently at the latest 1.9.5.5, but Its differant from the tables in a fresh install of 1.9.5.5. In the same way that my DNN installation has degraded over each upgrade and still has legacy stuff causing problems which arent in a fresh install.

---

Did you mean the yaf_xxx tables are different? Maybe you upgrade to a beta or rc version in the past?

But normally on an upgrade (From the Install Wizard) should altered the tables correctly. Otherwise you should take a look at the tables.sql file which creates/alters the tables on install/upgrade.