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: General / Classic ASP versions(v3.4.XX)
 Migrating data
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Curmudgeon
Starting Member

17 Posts

Posted - 14 March 2005 :  16:01:02  Show Profile
I need to migrate over three years of data from a database for Snitz version 3.3.03 to a new database for version 3.4.05. There does not seem to be anything on the forum in this area.

I have already done the setup for the new install and made some code changes for continuity from the older install. This has all been accomplished on my development machine. I am now ready to migrate it all to the production host.

Is there any difference between the SQL/Server database for version 3.3.03 and the SQL/Server database for version 3.4.05?

If so, is there a script, stored procedure or upgrade process to handle the migration?

If there are no differences between the old and new database schemas - will a simple SQL/Server Backup/Restore work?

TIA - The Curmudgeon.

Edited by - Curmudgeon on 14 March 2005 17:00:07

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 14 March 2005 :  17:06:20  Show Profile  Send ruirib a Yahoo! Message
You just need to install the code for the new version, change config.asp to point to the SQL 3.3.03 DB and run setup.asp. That will upgrade the database.


Snitz 3.4 Readme | Like the support? Support Snitz too
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.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07