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 |
|
sql_server_dba
Posting Yak Master
167 Posts |
 Posted - 2010-03-24 : 23:23:54
|
| Hi All, The Subject might be familiar to everyone, but i need the advise from experts here :P. Here is my situation....I have a SQL Server 2000 SE with 20 small databases. Now i want to upgrade them to 2005 using side-by-side migration. Here is my main problems i see on this for now..1) All the databases are interdependency. So how do i plan it and how do i check the interdependency?2) We used text data type in many places and i know that text data type is depreciated in 2005 and eliminated from 2008. So what do i need to do with it?3) The final one for now is we used systables in many scripts and i know that the systable names in 2005 changed from 2000. So how can we handle this?can anybody give me a clear picture about what way it would be better in order to do this....Thanks in Advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-03-25 : 04:36:32
|
I think Tara meant:2. Switch to varchar(max) now or wait until 2008. 2008 still supports it. |
 |
|
|
sql_server_dba
Posting Yak Master
167 Posts |
Posted - 2010-03-25 : 22:42:01
|
| Thanks for the reply..but right now i am not bothering about the backup/restore or detach/attach. The only thing i am worried about is inter dependencies. can anybody here let me know how to find the interdependencies between two databases?Thanks in Advance |
|
|
|
|
|
|
Upgrade from SQL 2000 to 2005