Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Craig328
Starting Member
3 Posts |
 Posted - 2008-03-07 : 23:47:56
|
| Hi all. I'll say from the get go that I'm no SQL guru. I'm primarily a web dev who has been given the data jobs kind of by default so I'm definitely no DBA.Anyway, having established my noobness, I have encountered an issue. The employer recently decided to upgrade our databases from 2000 to 2005 and I have been tasked to migrate the data from old to new. I have discovered the Import/Export Wizard and got it to move all the data in a dev database we use...but there was one problem. It seems that the tables in 2000 that had columns designated as identity columns do not have the identity attribute when they arrive in 2005.I haven't figured a way to alter them to give them that attribute once they're in 2005 so I'm wondering if there's something I can do/change in the import process that would retain the identity property of the columns if I were to re-import them.This is my first migration attempt so dumping it and starting over is no great loss...but any help would be most appreciated. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-08 : 01:42:50
|
| What you need to do is backup db on sql2k and restore it on sql2k5. |
 |
|
|
Craig328
Starting Member
3 Posts |
Posted - 2008-03-10 : 15:32:44
|
| Yeah, I tried that before but for whatever reason, 2K5 didn't want to accept it.I ended up manually fixing matters yesterday and it was a pain in the ass but all my data is over and I have identity working on the new tables again. Luckily, the app I'm building was still in the early phases so the identity values in the tables weren't being used for joins onto other tables yet.Thanks for the response. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-10 : 15:38:01
|
| 'Yeah, I tried that before but for whatever reason, 2K5 didn't want to accept it.'It should work. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-10 : 22:09:54
|
| Never had that issue. Did you get any error when restoring db on sql2k5? |
|
|
|
Craig328
Starting Member
3 Posts |
Posted - 2008-03-10 : 22:14:50
|
| I did get an error. I want to say it was missing a file it needed (wanna say something.mdb...but that's likely wrong). I'd normally go out and reproduce the error for you fellas but I hope you understand...what with my n00bness and all...since I got it working, I'm not one for messing with it.I'm a developer and stick very tightly to the mantra "if it ain't broke, don't f**k with it". I'd have said "fix it"...but if I'm fixing it, somebody already f**ked with it. :) |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-11 : 09:13:59
|
| ''I did get an error. I want to say it was missing a file it needed''What? What error you got while restoring? |
|
|
|
|
|
|
Help with data migration 2000 to 2005