| Author |
 Topic  |
|
|
Ez4arab
Junior Member
479 Posts |
 Posted - 12 November 2003 : 20:09:55
|
I have two databases i want to move topics form old database to new one. is it possible
i am using Access database.
|
Ez4arab web site Ez4arab | |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 12 November 2003 : 22:15:49
|
| not really... not easily at least because of all the id's used for topics, replies, users, etc. They need to be unique and relational. it is not impossible, but there will be a lot of data priming to do first and that my friend will take a long time based on the size of the database. |
 |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 13 November 2003 : 07:20:44
|
| it would not be an easy thing to do, importing the topics into access will give them new topic ids which would then need to be remapped to any replies they have, it is not something I would recommend to the faint hearted, but it does depend what exactly you want to do, how many topics are you talking about ? |
|
|
|
Ez4arab
Junior Member
479 Posts |
Posted - 13 November 2003 : 09:09:26
|
I know it is not an easy.
I move my members from old DB to new but i deleted some members so that it will give me Different IDs
old DB contain
318 of 758 Members have made 17,991 posts in 19 forums.
new change
I want to upgrade my database from Access to SQL so that I am thinking to merge both databases.
Because old DB give me errors so that I shift to another DB
Microsoft JET Database Engine error '80004005'
Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.
/oldforum/inc_header.asp, line 114
|
Ez4arab web site Ez4arab | |
Edited by - Ez4arab on 13 November 2003 09:17:21 |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 13 November 2003 : 10:12:47
|
| the members table is the least of your worries. like I already stated and HuwR reiterated, the topics and replies tables have unique id's that are related to one another. if you transfer your topics from one database to another, you would end up needing different topic id's, unique id's. once you change those id's, all your replies will need to have their parent id's changed as well, no small task and again something definately not recommended. |
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 13 November 2003 : 10:23:14
|
quote:
Microsoft JET Database Engine error '80004005'
Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt
This normally indicates that the permissions are wrong on your database. or your path is incorrect |
|
|
|
Ez4arab
Junior Member
479 Posts |
Posted - 13 November 2003 : 11:20:41
|
quote:
Originally posted by HuwR
quote:
Microsoft JET Database Engine error '80004005'
Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt
This normally indicates that the permissions are wrong on your database. or your path is incorrect
 my DB is out of root it is in same folder of my new DB 
How about to make new table for topic and replay!!!
This mean i need double code, is it right?
i think i will cancel the old db
|
Ez4arab web site Ez4arab | |
|
|
| |
Topic |
|
Topic Locked
