|
Home > Archive > MS SQL Server > March 2006 > NEW B - {WildPacket}
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
NEW B - {WildPacket}
|
|
| WILDPACKET 2006-03-14, 11:23 am |
| New to SQL.
Running SQL2000 on Win2000 Standard Sevrer. I have been asked to upgrade to
Windows 2003 Server and latest version of SQL server too.
Any articles on upgrading SQL2000?
What kidn of impact will upgrading from Win2000 to Win2003 will have on
exsitng SQL 2000? Only one DB in ouq SQL server, it is Black Berry DB.
Help plz
| |
| Sreejith G 2006-03-15, 3:23 am |
| No much issues migrating from win2000 to win2003
But while migrating from sql 2000 to sql 2005 you need to take care of if
there is any maintenance plan or DTS.
As there is only one DB, you can install sql2005 and manually migrate the DB
to sql2005. I recently did the same, but messed up with DTS part, still
working on that.
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"WILDPACKET" wrote:
> New to SQL.
>
> Running SQL2000 on Win2000 Standard Sevrer. I have been asked to upgrade to
> Windows 2003 Server and latest version of SQL server too.
>
> Any articles on upgrading SQL2000?
>
> What kidn of impact will upgrading from Win2000 to Win2003 will have on
> exsitng SQL 2000? Only one DB in ouq SQL server, it is Black Berry DB.
>
> Help plz
| |
| WILDPACKET 2006-03-15, 9:23 am |
| Thansk Sreejith for your response. So upgrading from win2000 to win2003 no
issues?
"Sreejith G" wrote:
[color=darkred]
> No much issues migrating from win2000 to win2003
>
> But while migrating from sql 2000 to sql 2005 you need to take care of if
> there is any maintenance plan or DTS.
>
> As there is only one DB, you can install sql2005 and manually migrate the DB
> to sql2005. I recently did the same, but messed up with DTS part, still
> working on that.
>
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and time
> asking back if its 2000 or 2005]
>
>
>
> "WILDPACKET" wrote:
>
| |
| Sreejith G 2006-03-15, 1:23 pm |
| Yes exactly and give your try and keep on posting :)
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"WILDPACKET" wrote:
[color=darkred]
> Thansk Sreejith for your response. So upgrading from win2000 to win2003 no
> issues?
>
>
>
> "Sreejith G" wrote:
>
|
|
|
|
|