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 |
|
newsqldba
Starting Member
14 Posts |
 Posted - 2007-08-28 : 19:37:13
|
| hi. i am currently migrating data from sql server 2000 to sql server 2005 and i was wondering if any of you can help me. i found this tutorial http://www.aspfree.com/c/a/MS-SQL-Server/Moving-Data-from-SQL-Server-2000-to-SQL-Server-2005/and it seems really straight forward. does this tutorial cover everything i need to do for data migration? do i need to watch out for anything? if anyone knows of a better tutorial please let me know. thanks for the help. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-28 : 20:57:43
|
| You can restore sql2k's db backup in slk5. |
 |
|
|
newsqldba
Starting Member
14 Posts |
Posted - 2007-08-28 : 21:49:07
|
| how do you go about doing that? i know how to restore backups in sql 2000 and the link tutorial i posted goes into the whole process of transferring data. i was just wondering if il come across any problems and what they will be. or if there are any other ways to transfer or migrate data other than the one on the tutorial. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-28 : 22:42:33
|
| Same statement as on sql2k, check books online for details. |
|
|
|
ujjaval
Posting Yak Master
108 Posts |
Posted - 2007-08-29 : 01:53:43
|
| I am also about to migrate my sql server 7.0 32-bit database to sql 2005 64-bit edition database. When I come to think of any problems that I may face, only thing concerns me is if there is something I have to do to put my database on 64-bit server? Because currently its running on 32-bit server.Anybody has any idea on it.Sorry, if I posted this into a wrong thread. I just thought its a similar issue. Ujjaval |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-08-29 : 02:31:45
|
| there is nothing special you need to do to convert a 32bit datbase to 64bit. You can either do backup/restore or you can do detach/attach. After detach/attach i would make sure that the datbase is at the right compatibility level though.-ec |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-08-29 : 07:30:03
|
| See also http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Migrating+to+SQL+2005+Hints+and+Tips |
|
|
|
|
|
|
data migration from sql 2000 to sql 2005