| Author |
 Topic  |
|
|
scoob
Starting Member
10 Posts |
 Posted - 12 February 2004 : 05:28:10
|
Ok, I've been reading here for hours now and haven't seen a post on this topic. Can I be the only one cursed with this problem??
Anyway, I've followed the steps listed here for migrating a db from Access to MSSQL number of times now, and it has been very clear each time that some thing went wrong.
After poking around in EM I noticed that the FORUM_CONFIG_NEW table in MSSQL only has 141 rows (sometimes 151) rather than the 183 rows it has in Access. I didn't look at any other tables yet.
I'm really confused, and don't know enough about SQL to manually move the remaining rows.
Anyone here encountered this problem?? Any one know of a solution?? |
Edited by - scoob on 12 February 2004 11:36:01 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 12 February 2004 : 11:41:19
|
| did it give you any errors when doing the transfer ? I can't think of any reason it would only transfer part of a table |
 |
|
|
scoob
Starting Member
10 Posts |
Posted - 12 February 2004 : 13:32:42
|
quote:
Originally posted by HuwR
did it give you any errors when doing the transfer ? I can't think of any reason it would only transfer part of a table
Nope, no errors at all. Everything seemed to go smoothly. But each time I migrate I get the same results--missing rows.
I've tried running setup.asp, and then migrating the tables over. I've tried creating a blank db and migrating the tables. I've tried all kinds of variation, all with the same results.
Not being an db person I'm that I'mdoing something wrong--but I just can't figure out what?? |
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 13 February 2004 : 20:32:52
|
| Are you using the DTS Wizard to export the data, if so which option are you selecting, copy data, copy objects ? I've never seen DTS do this myself personally |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
NorwegianViking
Junior Member
Denmark
119 Posts |
Posted - 14 February 2004 : 20:57:31
|
Hi scoob
Strange...
I did some tests to see if I could duplicate your problem, and got the same problem as you. Was very puzzled, until I discovered that I had specified the wrong Access file when I created the Access Connection in the DTS... I had pointed to an older Access file, which actually had fewer records in FORUM_CONFIG_NEW. Could it be that simple?  |
kind regards
NorwegianViking
Mod installation for beginners | User registration problems?
|
|
|
|
scoob
Starting Member
10 Posts |
Posted - 14 February 2004 : 22:48:15
|
quote:
Originally posted by Gremlin
Are you using the DTS Wizard to export the data, if so which option are you selecting, copy data, copy objects ? I've never seen DTS do this myself personally
The short answer is: yes. I've tried variations of all the import options. I'm going to try again tomorrow, and i'll post the methodical details. |
|
|
|
scoob
Starting Member
10 Posts |
Posted - 14 February 2004 : 22:49:22
|
quote:
Originally posted by NorwegianViking
Hi scoob
Strange...
I did some tests to see if I could duplicate your problem, and got the same problem as you. Was very puzzled, until I discovered that I had specified the wrong Access file when I created the Access Connection in the DTS... I had pointed to an older Access file, which actually had fewer records in FORUM_CONFIG_NEW. Could it be that simple?
I'm pretty sure I'm pionting to the right Access file. I will double check this. I hope that is the problem. |
|
|
| |
Topic |
|
Topic Locked
