I am attempting to move my forum from one server running IIS 5.0 and MS SQL7.0 to a server running IIS6.0 and MS SQL2005. What are the best steps for me to take to accomplish this from a SQL standpoint? Is there some sort of database change needed when going between these versions, or will SQL take care of it?
You should create the tables in the new database by running setup.asp. That will ensure the tables are properly created. Once that is done, you need to use DTS to perform the data transfer between the databases. You can use DTS as explained here:
You should create the tables in the new database by running setup.asp. That will ensure the tables are properly created. Once that is done, you need to use DTS to perform the data transfer between the databases. You can use DTS as explained here:
Once that is done, you should have no problems with the new server.
Is there a blank SQL db available for first time users? we use the older version 2.0 which does not support any upgrade procedures and are will to toss outr old db and go to sql. Thanks- Don
Running setup.asp will create all the neccessary tables and fields for you. Obviously, you'll need to get your host to create the db for you first and edit config.asp to point to it.
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.”
Topic Locked
Posted - 27 September 2006 : 13:57:20
