Post reply

SQL 2008 Web Edition

  • March 2, 2011 at 3:42 am

    #388948

    Hi everyone

    We have a SQL Server 2008 R2 Enterprise Edition installed at our offices.

    We are looking into creating white label websites that will all use some of our tables.

    We want to host this data on a dedicated server with another ISP. They offer the Web Edition at a decent price and I was wondering if the following will be possible with a remote: Web and local Enterprise edition.

    - Some of the searches use FTS, will this be possible to create/populate on the Web Edition

    - Will I be able to setup transactional replication with a push subscription from local->remote

    - Will I be able to access the remote DB using my SSMS at the office

    That way I can keep everything up to date locally and replicate the data over.

    Thanks for any advise given.

  • March 2, 2011 at 3:55 am

    #1293401

    I'd recommend having a look here, which answers all of those questions:

    http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

  • March 2, 2011 at 4:01 am

    #1293402

    Thanks Howard, very good link.

    Seems I will be able to achieve what is necessary using the Web Edition.

    Thanks again

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

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