question

Fizz avatar image
Fizz asked

Downgrading migration - SQL 2008 Enterprise to 2008 Standard

Hi,

I have a need to move 2 small Databases from a 2008 Enterprise platform to 2008 Standard. One is a production DB the other a reporting DB for Production. No Change Data Capture processes are included so I am hoping it is a relatively simple process. The databases have the regular tables, user defined functions and stored procedures, a few triggers(some are across the 2 DBs) and SSIS packages for ETL processes.

I was planning on backing up the enterprise Databases and simply restoring them on the Standard platform. Is this the right way to go? If someone could point me in the righ tdirection it would be appreciated.

Thanks

sql-server-2008
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Matt Whitfield avatar image
Matt Whitfield answered

Personally I would backup the enterprise databases, then detach them, copy them over to the standard platform, and attach, that will be quicker than a backup then restore.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Gary avatar image
Gary answered

Hello Matt,

Are you sure this will work? Enterprise has some featurs like compression, partitioning and indexed views that are not supported by Standard. What will happen to those?

Regards, Gary

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
The attach would fail, I believe. But really if you're downgrading, you should be sure that all features you use are supported, otherwise there's no point in downgrading...
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.