SQL Recommendations?

[Chrisopia]

I'm ready to upload my access database to an online SQL server. My current web server doesn't have open SQL abilities, so I'll have to subscribe to another service.

I have no idea what I'm looking for or what price range is right? Any advice would be useful.

 

[Rx_]

Know it has been a while. Did you figure it out? If you did would you share your result?

About three years ago, I had a SQL Server. It had a LINKED SERVER to a Web site with SQL Server that published daily stock market information for a specific industry.
In SQL Server Management Studio (SSMS) to to Server Objects - then to Linked Servers.

I don't have the code in front of me from back then. I think the web server would go in the place of 'mr.world' followed by the port number, then the name of the SQL Server.
Basically, this reads the tables (or views) and can become part of the local SQL Server DB table collection.

A T-SQL script would look something like this.
USE [master]
GO
--Create the Oracle Linked Server:
EXEC sp_addlinkedserver 'FinderView73' , 'Oracle', 'OraOLEDB.Oracle', 'mr.world:1521/Dens249'

EXEC sp_addlinkedsrvlogin 'FinderView73', 'FALSE', NULL, 'UserName', 'Password'

 

[mdlueck]

It sounds like you are shopping for a provider to host a SQL database at which allow external connection to the SQL database across the Internet.

Usually hosting providers block external connections directly to the SQL database with less expensive "shared web hosting" accounts. Those are intended to support the web hosting package, not for database applications connecting directly to those databases.

If you were to go with a little bit more expensive option, then you would have root / admin permissions, such as with a Virtual Private Server (VPS). You could install a suitable SQL database in that VPS environment, and configure the security to suit your needs. Note: Using this option, suddenly you become the technical admin for a server on the wide open Internet, and get to put up with all of the hacking that goes on.

 

[ButtonMoon]

I'm ready to upload my access database to an online SQL server. My current web server doesn't have open SQL abilities, so I'll have to subscribe to another service.

You mean you want to port a Jet/ACE database to a SQL DBMS? The first thing you can do is get the DBMS software installed locally if you haven't already. Migrate your database to SQL Server, MySQL (or whatever) on your own servers and do any necessary redevelopment and testing. A database design built for Jet/ACE isn't necessarily suitable for a SQL DBMS and so may need a certain amount of work. Same goes for the application design for that matter. I would suggest that there's no sense paying for a hosted service until you've built and tested the solution you want to put on it.