2005 Enterprise Edition to Standard Edition with Table Partitions

All,
I have an issue with Table Partitioning in that only Enterprise/Developer
Editions support this feature.
To explain this easier;
We have 2 servers, Live and Dev.
Live is using EE and Dev is using SE.
When the next Dev cycle starts a backup of Live is applied to Dev and the
developers create sql scripts for the new SPs etc.
However I'm looking at implementing Table Partitioning which restores on
Standard Edition but wont start the DB.
Does anyone have any suggestions/recommendations on what i can do to get the
backup restored and accessable to the Developers without installing EE on th
e
Dev Server or removing the partitions on the live server?> Does anyone have any suggestions/recommendations on what i can do to get
> the
> backup restored and accessable to the Developers without installing EE on
> the
> Dev Server or removing the partitions on the live server?
I suggest you use SQL Server Developer edition on the development server.
It's considerably less expensive than Standard and has the same features as
Enterprise but cannot be used in production.
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:58D06E4B-AD2E-439A-902E-4026C43E20E3@.microsoft.com...
> All,
> I have an issue with Table Partitioning in that only Enterprise/Developer
> Editions support this feature.
> To explain this easier;
> We have 2 servers, Live and Dev.
> Live is using EE and Dev is using SE.
> When the next Dev cycle starts a backup of Live is applied to Dev and the
> developers create sql scripts for the new SPs etc.
> However I'm looking at implementing Table Partitioning which restores on
> Standard Edition but wont start the DB.
> Does anyone have any suggestions/recommendations on what i can do to get
> the
> backup restored and accessable to the Developers without installing EE on
> the
> Dev Server or removing the partitions on the live server?