Data transfer from Sql Server 2008 Enterprise edition to @008 Web Edition

  • Hi

    Our client is deploying the application using SQL Server 2008 Web Edition, we r developing using SQL 2008 Enterprise edition.

    The DB contain some tables with data to run the application initially(Default settings)

    We don't have the license for Web Edition as we have only Enterprise edition.

    I know it is not possible to take the DB backup from enterprise edition and restore it to Web edition.Is it possible to generate the Script with data from enterprise edition and

    run it into Web Edition.

    One more Question

    Does sql server 2008 web edition has Sql agent to run the automate backup and index maintenance jobs.Can we use Maintenance plan wizard as we use in Enterprise edition

    thank you

  • dilipd006 (3/1/2012)


    I know it is not possible to take the DB backup from enterprise

    Do you?

    It is possible provided you arent using any enterprise specific features.

    dilipd006 (3/1/2012)


    editionOne more Question

    Does sql server 2008 web edition has Sql agent to run the automate backup and index maintenance jobs.Can we use Maintenance plan wizard as we use in Enterprise edition

    thank you

    It does. Never installed it but its not a feature you'd want removed if you were hosting a website.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply