| Author |
 Topic  |
|
|
Aaron S.
Average Member
USA
985 Posts |
 Posted - 11 May 2002 : 15:09:30
|
My ISP seems to have terrible SQL support as the Db is always crashing!
I would like to try Access to see if it is worth converting back to it.
What is the best way to move back from SQL to Access?
--Aaron
DOWNLOAD GREAT NEW MODS HERE |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 May 2002 : 18:34:18
|
Well I've never tried it, but maybe using DTS with the SQL database as source and a clean Access Snitz DB as the destination (after removing the the few initial records a clean Access DB includes) .
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 11 May 2002 18:38:25 |
 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 11 May 2002 : 20:22:02
|
I don't think Access supports a IDENTITY INSERT, you may run into problems with the ID fields becoming renumbered if you have any tables with non-sequential ID numbers.
======
Doug G
====== |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 May 2002 : 22:29:59
|
Doug is right, DTS won't work, I believe because of the Identity insert (I just ran a small test to check). There is another, although envolving more effort approach: import all SQL tables to Access through ODBC. As far as I know all data will likely be adequately imported.
Primary and foreign keys won't be defined as such after the import, but you can configure each table individually and fix that afterwards. You'll also need to setup table relationships, but this hypothese looks viable to me.
Anyhow I only played with it a bit. If you do it you'll need to test the resulting DB quite thouroughly to be sure everything really works...
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 11 May 2002 22:55:55 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 May 2002 : 23:13:14
|
Just an update on this: the import strategy seems to work, after some tests I've made on my forum (small number of members and posts though).
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Aaron S.
Average Member
USA
985 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 12 May 2002 : 07:56:56
|
To be sure you'd probably need to have look at a clean database.
Anyway a good quick guide would be the field names. Anything with a name that terminates with an ID should either be a primary key, index or foreign key. I'm writing this from the top of my head, but my description probably covers all situations.
I've seen sometimes where the primary key is composed (like in FORUM_TOPICS). I'd say that is really not necessary (you could just use TOPIC_ID as primary key and the others as normal indexes).
Anyway with these "rules of thumb" I'm sure you can fix the imported DB structure in no time.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
| |
Topic |
|
Topic Locked
