Author |
Topic |
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-05-13 : 23:50:30
|
best way to copy the whole db from 2k5 to 2k.thanks |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-13 : 23:52:51
|
SSIS,bcp. |
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-05-14 : 00:40:49
|
2k doesnt support 2k5 db. PLSPls only experts! No noobies. |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2008-05-14 : 02:15:30
|
Use export-import utility in SQL 2K5.Thats the simplest way.RKNAIR |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-05-14 : 02:31:17
|
SQL 2005 databases cannot be attached to a SQL 2000 instance. Backups of a SQL 2005 database cannot be restored on SQL 2000.You will have to, as SoDeep suggested, script the database out and bcp the data out. Apply the script on a SQL 2000 server then import all the data--Gail Shaw |
|
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
Posted - 2008-05-14 : 09:12:08
|
quote: Originally posted by funketekun 2k doesnt support 2k5 db. PLSPls only experts! No noobies.
It amazes me that anybody bothers to answer him anymore. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-14 : 09:51:49
|
quote: Originally posted by DavidChel
quote: Originally posted by funketekun 2k doesnt support 2k5 db. PLSPls only experts! No noobies.
It amazes me that anybody bothers to answer him anymore.
funketetun,Stop writing 'Pls only experts! No noobies.'.It irritates people |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-05-14 : 10:07:37
|
quote: Originally posted by DavidChel
quote: Originally posted by funketekun 2k doesnt support 2k5 db. PLSPls only experts! No noobies.
It amazes me that anybody bothers to answer him anymore.
I just wanted to see if he replied saying I was too much of a 'noobie' to be of any help. --Gail Shaw |
|
|
X002548
Not Just a Number
15586 Posts |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-14 : 10:34:15
|
Copy all the data out line by line into an Excel spreadsheet, then create an input screen and put it all back in to your 2000 database.Hopefully that is exshpurt enough for you. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-14 : 10:39:10
|
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2008-05-14 : 10:42:04
|
quote: Originally posted by funketekun 2k doesnt support 2k5 db. PLSPls only experts! No noobies.
funketun -- if you post "experts only" one more time, I am going to discuss this with the other moderators and we'll probably lock your account. It's rude, it's not funny, enough is enough.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
X002548
Not Just a Number
15586 Posts |
|
X002548
Not Just a Number
15586 Posts |
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-14 : 11:48:10
|
quote: Originally posted by funketekun
quote: Originally posted by RickD Copy all the data out line by line into an Excel spreadsheet, then create an input screen and put it all back in to your 2000 database.Hopefully that is exshpurt enough for you.
we have like many tables. i cant do that.
Then why ask stupid questions and then ignore the replies you get that actually tell you how to do what you asked? |
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-05-14 : 11:49:24
|
ok relax i think i got it. |
|
|
X002548
Not Just a Number
15586 Posts |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-05-14 : 12:35:51
|
damn its not working.anyone know how to do it?i used the copy object from ssis and it didnt work |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-14 : 12:40:07
|
Do as RickD has said? you won't miss any data."Copy all the data out line by line into an Excel spreadsheet, then create an input screen and put it all back in to your 2000 database." Classic one. |
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-05-14 : 12:46:03
|
quote: Originally posted by RickD Copy all the data out line by line into an Excel spreadsheet, then create an input screen and put it all back in to your 2000 database.Hopefully that is exshpurt enough for you.
using ssis or bcp?can u elaboreate? |
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2008-05-14 : 12:46:50
|
looks like u dont know or something. |
|
|
Next Page
|