| Author |
 Topic  |
|
psnash
Starting Member
1 Posts |
 Posted - 19 July 2004 : 16:29:02
|
We used Access on the previous version of Snitz forums.
We downloaded the most recent version and ran setup. It upgraded our Access to the latest version as well.
Here is my question. We upgraded and the upgrade converted the Access DB apparently w/o problems. However, I would like to have had it upgrade from Access to SQL Server, but was not prompted.
I went ahead with the upgrade on Access, and then imported the Access DB into SQL Server.
Importing from Access only allows you to copy data into the sql server database. At that point, you loose Identity Inserts on several tables. Also, you lose the default value on the field t_view_count in the topics table (not allowing you to view READS on the topics page).
Was there an easier way and/or what did I miss?
Steve |
Edited by - psnash on 19 July 2004 16:29:19 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 19 July 2004 : 17:27:11
|
Search these forums, and the archived posts too, for many threads on converting from Access to SQL Server.
The best way seems to be to let Snitz create all the SQL Server tables, and then copy just the data from your access tables. The upsize wizard or DTS import of Access hasn't worked well for most people that have tried that method.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
 |
|
|
superkooi
Starting Member
Netherlands
5 Posts |
Posted - 04 January 2005 : 17:57:11
|
I just upgraded from access to MS SQLserver2K using import DTS. I had to make a few adjustments afterwards but it's working perfectly. The manual changes i had to make after converting were
1. Look for autonumbering in the accesstable and manualy correct that on SQLserver tables (were not converted)
2. Look in all the accesstables for default values and correct them in SQLserver tables manualy (were not corrected)
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 04 January 2005 : 18:45:11
|
That would have been avoided if you had just created the tables first, by running setup.asp. That's the path we recommend and it can save all the trouble. Also, by doing the import, no indexes were created for the SQL Server tables, which may give you performance problems in the future.
I would recommend that you recreate the tables, by running setup.asp?RC=5 and then import the data again, making sure identity insert and delete existing table records are chosen as options for each table, in the DTS transform column. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
superkooi
Starting Member
Netherlands
5 Posts |
Posted - 26 January 2005 : 17:12:12
|
You are probably right. Correction; you are right
But apparantly my intranetforum is really working like a charm. Could you tell me how the fix the alleged indexproblem on my forums if i want to do that manualy in SQLserver. Yes i know; i have al lot of time and i upgraded my forum without any knowledge of SQLserver. If i do it manualy i may get more knowledge about SQLserver databases!
Thanx in advance
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
superkooi
Starting Member
Netherlands
5 Posts |
Posted - 27 January 2005 : 04:21:10
|
Thanx again,
Just to be on the save side. Could you check the image out and answer me if i'm in the right direction!
 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 January 2005 : 06:02:26
|
What exactly do you want me to confirm? Whether that is the way to create the indexes?
Looks like you're creating a three column index for the topics table. I would say that is the way to do it. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
superkooi
Starting Member
Netherlands
5 Posts |
Posted - 27 January 2005 : 06:58:23
|
That was all i needed to know.
Thanx for the help |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tekgirl
Starting Member
USA
40 Posts |
Posted - 28 January 2005 : 12:46:43
|
quote:
Originally posted by ruirib
That would have been avoided if you had just created the tables first, by running setup.asp. That's the path we recommend and it can save all the trouble. Also, by doing the import, no indexes were created for the SQL Server tables, which may give you performance problems in the future.
I would recommend that you recreate the tables, by running setup.asp?RC=5 and then import the data again, making sure identity insert and delete existing table records are chosen as options for each table, in the DTS transform column.
So, ruirib, if I want to take my existing Access DB and upgrade to SQL Server, should I just change the db string in config.asp to sql server and run setup.asp? Sorry if this is a repeat question, but I have never used SQL server before, and I don't want to cause any problems for my forum. And if I do that, what is the best way to import the data from my existing access db?
Thanks! |
--tekgirl |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tekgirl
Starting Member
USA
40 Posts |
Posted - 28 January 2005 : 21:49:33
|
| Thank you! Exactly what I needed. |
--tekgirl |
Edited by - tekgirl on 28 January 2005 21:49:51 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tekgirl
Starting Member
USA
40 Posts |
Posted - 30 January 2005 : 15:58:46
|
Just wanted to thank you for making my transition from MS Access to MS SQL as painless as possible. I did make a few mistakes, but managed to fix them on my own. Making mistakes is quite inevitable when learning something knew, but at least my mistakes were minimalized because of your help. So...thanks! 
That being said, I discovered a small problem ;) I have lost the ability to config Active Users in the admin options. That feature seems to have disappeared. Any ideas? Active Users seems to be working: http://www.btcnj.com/forum/default.asp, just no way to configure it as before. |
--tekgirl |
Edited by - tekgirl on 30 January 2005 16:48:18 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
