|
Home > Archive > MS SQL Server > January 2006 > SQL Server 2005 Express on SQL Server 2000
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 |
SQL Server 2005 Express on SQL Server 2000
|
|
| Mark Ware 2006-01-19, 11:23 am |
| Can databases created on SQL Server 2005 Express be ran on SQL Server 2000?
In this day of cost-cutting, the company wants to hold off on upgrading our
production boxes from 2000, however, we have users that want to do
development in 2005 Express. Any considerations or gotchas to be aware of?
--
Mark
| |
|
| You won't be able to backup/restore or attach/detach etc but you could
always migrate the objects via DTS/SSIS/BCP etc. There may be certain
compatibility issues if you make use of the new data types on offer in 2005
--
HTH. Ryan
"Mark Ware" < MarkWare@discussions
.microsoft.com> wrote in message
news:6474DFFF-21E2-4464-9615- 03E98A820E60@microso
ft.com...
> Can databases created on SQL Server 2005 Express be ran on SQL Server
> 2000?
> In this day of cost-cutting, the company wants to hold off on upgrading
> our
> production boxes from 2000, however, we have users that want to do
> development in 2005 Express. Any considerations or gotchas to be aware of?
> --
> Mark
|
|
|
|
|