Author |
Topic |
robertnzana
Starting Member
42 Posts |
Posted - 2008-06-02 : 16:00:12
|
I have a 2005 SQL SERVER db. I'm trying to export it to a 2000 db. I delete all the tables in the 2000 db then try to run an export from Management Studio 2005 and the tables go over fine, but no PK field is defined, no already-defined identity seed, etc... |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-02 : 17:07:37
|
Export/Import doesn't take care of Identity and Contraints. you have to manually apply. |
|
|
robertnzana
Starting Member
42 Posts |
Posted - 2008-06-02 : 17:17:40
|
no way to auto script it for 2000? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-02 : 22:35:19
|
Tried with copy db object task in ssis? |
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-06-03 : 15:08:30
|
As I know you should not be able to go from higher version to lower version, But you always can go to Lower to Higher version.ManojMCP, MCTS |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-03 : 15:21:30
|
quote: Originally posted by mdubey As I know you should not be able to go from higher version to lower version, But you always can go to Lower to Higher version.ManojMCP, MCTS
Yes you can.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
robertnzana
Starting Member
42 Posts |
Posted - 2008-06-03 : 15:33:24
|
i ended up generated a script in 2005 for all my tables, pk's, etc...then i ran it in 2000 and it created itthen i exported the data from 2005 to access, then imported the access tables to 2000then i recreated the diagram from scratchseems to be workingwhat a pain! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 15:59:32
|
Did you take look at ssis? |
|
|
robertnzana
Starting Member
42 Posts |
Posted - 2008-06-03 : 19:59:24
|
not yet because i didn't know about it until recently and now my data is ok ;)thanks y'all - i will look at the utility the next time i should need to do something similar! |
|
|
|