Hello,
Our company has an existing yaf forum running on Server 2003 SBS which as far as i can tell is running version 1.9.0 (i did not install it). It is using SQL Server 2000.
We are upgrading the IT and i need to somehow make a fresh yaf install on another server (Server 2003 - 32bit, can't see anything when i try it on 64 bit) and copy over the existing forum.
I have managed to startup an empty forum using the 1.9.0 zip file i found on the old SBS server using SQL Server 2008.
I have tried using the export wizard to copy the database across. this is initially succesful and creates a new database. however when i then try and run the default.aspx file it runs into errors saying that the sys_vaccess table exists, if i delete it then it just creates another error instead... i can supply screenshots if required
lots of the instructions in the install.txt seem to relate to upgrading a database on a single machine and not transferring it. i tried taking a backup, but of course the new machine doesn't know that a backup was ever made of any database when i try and restore....
What is the best way to try and effect this transfer? I am making it up as i am going along, i have no experience of using ISS or SQL except that which i have gleaned in the last few days. so my problems are highly likely caused by general inexperience.
I appreciate any help that you can provide me with in this matter
dc