Member Avatar for cr8vnrg

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

  • 2 Contributors
  • 1 Reply
  • 106 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by demo
Member Avatar for demo

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.