| Author |
 Topic  |
|
|
MRWebmaster
New Member
76 Posts |
 Posted - 21 March 2004 : 21:05:07
|
I just upgraded from Access to SQL Server. I created the SQL Server tables manually by hand and used DTS to transfer all data. Those steps are complete. My only worries are with the relationship settings. (eg. Cascading UPDATE/DELETE etc...), is there anyway someone could post what those settings should be for the 10 relationships?
Thanks! |
Matt Brown, MCP
MetalReview.com Discussion Board |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 March 2004 : 22:30:12
|
Why didn't you just use setup.asp to create the tables? If you run setup.asp configured to use a database with no tables, it will create the tables for you. You can done DTS the data from Access.
Table creation is done by inc_create_forum_mssql.asp. Have a there for those settings... or take the shortest and trouble free path of deleting the tables, running setup.asp and then DTSing the data again. That will ensure you're not missing anything.
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
MRWebmaster
New Member
76 Posts |
Posted - 21 March 2004 : 22:59:36
|
Oh, I prefer to do things the long/hard way! *hahahh* (just kidding)
I'll take a look at inc_create_forum_mssql.asp. I certainly don't want to do all of the DTSing again.
Thanks for the advice.
(Edited 10:25pm 3/21/2004)
Ok, could someone be so kind as to tell me which checkboxes need to be checked in the Relationship properties for the 10 Relationships in the database?
Lets use a quick lettering system for each relationship:
RELATIONSHIP PROPERTY CHECKBOXES - SQL Server 2000
(A) Check existing data on creation
(B) Enforce relationship for replication
(C) Enforce relationship for INSERTs and UPDATEs
(D) Cascade Update related fields
(E) Cascade Delete related records
RELATIONSHIPS - for each relationship below, post the letters from above of which items need to be CHECKED only.
FORUM_MEMBERS [MEMEBER_ID]-->FORUM_TOPICS [T_AUTHOR]
FORUM_MEMBERS [MEMBER_ID]-->FORUM_MODERATOR [MEMBER_ID]
FORUM_MEMBERS [MEMBER_ID]-->FORUM_REPLY [R_AUTHOR]
FORUM_TOPICS [CAT_ID]-->FORUM_REPLY [CAT_ID]
FORUM_TOPICS [FORUM_ID]-->FORUM_REPLY [FORUM_ID]
FORUM_TOPICS [TOPIC_ID]-->FORUM_REPLY [TOPIC_ID]
FORUM_TOPICS [CAT_ID]-->FORUM_FORUM [CAT_ID]
FORUM_TOPICS [FORUM_ID]-->FORUM_FORUM [FORUM_ID]
FORUM_MODERATOR [FORUM_ID]-->FORUM_FORUM [FORUM_ID]
FORUM_FORUM [CAT_ID]-->FORUM_CATEGORY [CAT_ID] |
Matt Brown, MCP
MetalReview.com Discussion Board |
Edited by - MRWebmaster on 21 March 2004 23:47:38 |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 22 March 2004 : 03:26:27
|
| there are no database relationships defined |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 22 March 2004 : 04:03:54
|
| I'd highly recommend doing as Ruirib advised, run the setup.asp to create everything otherwise you are more than likely going to run into other problems later on that may not be immediately apparent. DTS'ing the data isn't really that hard once you've got the table created correctly, pretty much setup the job and go read a book while you wait for it to finish. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
MRWebmaster
New Member
76 Posts |
Posted - 22 March 2004 : 08:04:43
|
I'm in a situation here where I cannot have ANY downtime. We just started a major advertising campaign and are anticipating a ton of traffic. DTS'ing isn't hard I agree, but I would have to go back in and also re-create the tables for all of the MODs I have installed when in reality, all it would take, is for one of you to open Enterprise Manager, open a database diagram, click on each of the ten relationship bars [properties], and list what should be checked. I've got all of the data types correct.
Anyone please?  |
Matt Brown, MCP
MetalReview.com Discussion Board |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 22 March 2004 : 08:38:27
|
THERE ARE NO RELATIONSHIPS DEFINED.
all inserts/updates and deletes are done in code |
|
|
|
MRWebmaster
New Member
76 Posts |
Posted - 22 March 2004 : 09:52:56
|
When I open snitz_forums_2000.mdb in the 'Relationship' editor, I see 10 relationships defined (various 1 to many // many to many etc.) Those are relationships right? And they didn't just magically appear. Or am I missing something?
When I re-created that database in SQL Server (by hand), I also re-created a diagram in Enterprise Manager that was the same as the one in Access, linking the various tables by keys etc.
Ok, you say all deletes are done in code; are you saying that no tables depend on 'Cascading deletes'? I can just clear all of those checkboxes in the properties of those 'relationships'? |
Matt Brown, MCP
MetalReview.com Discussion Board |
Edited by - MRWebmaster on 22 March 2004 10:17:45 |
|
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 22 March 2004 : 10:22:16
|
quote:
Originally posted by MRWebmaster
Ok, you say all deletes are done in code; are you saying that no tables depend on 'Cascading deletes'? I can just clear all of those checkboxes in the properties of those 'relationships'?
That would be correct. Cascading deletes aren't defined because sql server didn't support them before 2000. I don't think MySQL does, but I could be wrong about that. |
Dave Maxwell
Barbershop Harmony Freak |
|
|
|
MRWebmaster
New Member
76 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 23 March 2004 : 06:08:17
|
| Have you checked all the constraints throughly too? any problems there will cause some weird errors later as I eluded to earlier. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
| |
Topic |
|
Topic Locked
