Snyc'n Local SQL database online

Expand Post »

Hi,

We have a accounting/inventory program that uses MS SQL as the database, with VB and Access for reporting. We want to make the database available online. ie.. Our clients can search the inventory and make orders from it. We do not want to install a local web server inhouse. What is our best option for creating this.. should we stick to a MS SQL database /ASP online or export our data and then re-import it to a mySQL/PHP database online. The database online should be able to sync with the local database on a daily basis as well.

thanks in advance for any insight you can offer,
Jacob

Similar Threads

Best choise for a local application database in C#
Insert into sql database in ASP.NET
built in login and createuser wizard but for a remote SQL database? how to change? in ASP.NET
Problem Inserting into SQL database on server in ASP.NET
Update SQL database automatically using VB6 in Visual Basic 4 / 5 / 6

cr8vnrg

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Apr 2005

Permalink

Apr 26th, 2005

Re: Snyc'n Local SQL database online

Hi

How is the client to view the data if you don't have a web server to display it! You can setup a server anywhere and then just allow remote connections with limited access to your current in house database. What's the point of mirroring a database that already exists? Unless your doing some sort of version control a mirror is a waste of time to implement and maintain!

demo

demo

Reputation Points: 10

Solved Threads: 2

Newbie Poster

Offline

18 posts
since Jan 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Do uncompression of disk drives affects my Database?

Next Thread in MS SQL Forum Timeline: database won't give correct permissions

DaniWeb Message

Cancel Changes

User Name
Password