July 24, 2013 at 11:03 am
All right folks, I'm looking for various popular database hosting solutions. Preferably places that use their own images with fully functional database engines (unlike SQL Azure that seems to strip nearly everything off an image..)
Does anyone have any recommendations?
Erin
July 24, 2013 at 11:31 am
Azure offers SQL Servers directly, not just the PURELY hosted database, you get a windows machine with SQL already installed.
Amazon offers a similar service.
What specifically are you looking for?
CEWII
July 24, 2013 at 2:05 pm
I looked at Azure first but according to this:
http://msdn.microsoft.com/en-us/library/windowsazure/ff394115.aspx
(Summed up...)
The following features that were new to SQL Server 2008 R2 are not supported by Windows Azure SQL Database:
SQL Server Utility
SQL Server PowerShell Provider. PowerShell scripts can be run on an on-premise computer, however, and connect to Windows Azure SQL Database using supported objects (such as System Management Objects or Data-tier Applications Framework).
Master Data Services
The following features that were new to SQL Server 2008 are not supported by Windows Azure SQL Database:
Change Data Capture
Data Auditing
Data Compression
Extended Events
Extension of spatial types and methods through Common Language Runtime (CLR)
External Key Management / Extensible Key Management
FILESTREAM Data
Integrated Full-Text Search
Large User-Defined Aggregates (UDAs)
Large User-Defined Types (UDTs)
Performance Data Collection (Data Collector)
Policy-Based Management
Resource Governor
SQL Server Replication
Transparent Data Encryption
SQL Server 2005 Features Not Supported by SQL Database
The following features that were new to SQL Server 2005 are not supported by Windows Azure SQL Database:
Common Language Runtime (CLR) and CLR User-Defined Types
Database Mirroring
Service Broker
Table Partitioning
Typed XML and XML indexing is not supported. The XML data type is supported by Windows Azure SQL Database.
Other SQL Server Features Not Supported by SQL Database
The following features from earlier versions of SQL Server are not supported by Windows Azure SQL Database:
Backup and Restore
Replication
Extended Stored Procedures
SQL Server Agent/Jobs
Seems to render an Azure SQL Server instance nearly non-functional for my purposees.
I'm currently looking at MyHosting.com Hyper-V and it looks promising.
Basically I'm looking for a fully functional SQL Server 2008 R2 or higher instance for a reasonable price.
July 24, 2013 at 2:38 pm
I think you would want to look at:
http://www.windowsazure.com/en-us/pricing/details/virtual-machines/#service-sql-server
You get a VM with SQL all licensed..
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply