Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Migrating to new SQL server
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

icexe
Starting Member

4 Posts

Posted - 02 August 2002 :  13:05:41  Show Profile
Sorry if this is a silly question. I installed 3.03 a few months back and its working great. However, I need to migrate the forums to a different SQL Server. I am simply moving from one SQL 7 Server to another SQL 7 server.

Since its been so long since I set this up, I sort of forgot some of the procedures involved. Do I just change the name of the server in the connection string, then run setup.asp?

Thanks for any help on this

icexe
Starting Member

4 Posts

Posted - 02 August 2002 :  14:06:15  Show Profile
nevermind, I figured it out.

:-)

Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 03 August 2002 :  11:43:21  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
Just for future reference for anyone else wanting to do this..

1. Change config.asp file to point to your new SQL Server
2. Run setup.asp to create the tables
3. Use DTS to transfer the data from your old SQL Server into the new SQL Server tables that were just created.

Brad
Web Hosting with SQL Server @ $24.95 per month
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07