•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 361,043 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,069 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 2514 | Replies: 1
 |
•
•
Join Date: Apr 2005
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Snyc'n Local SQL database online 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
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
•
•
Join Date: Jan 2005
Posts: 18
Reputation:
Rep Power: 4
Solved Threads: 2
Newbie Poster
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
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
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
•
•
•
•
ajax asp backup black friday breach customers daniweb data protection database design developer development distance education education experiment funds gift cards government hacker holiday holiday shopping india intel internet investments media microsoft msdn news normalization office online online education online shopping pc portfolio publishing retail retail stocks security server shopping software sql stocks strayer survey tips vista web
- built in login and createuser wizard but for a remote SQL database? how to change? (ASP.NET)
- Problem Inserting into SQL database on server (ASP.NET)
- Update SQL database automatically using VB6 (Visual Basic 4 / 5 / 6)
- SQL Database loop (C#)
- Insert into sql database (ASP.NET)
- Process very slow - SQL Database (MS SQL)
- Best choise for a local application database (C#)
- Help with Roles Stored in SQL database (ASP.NET)
Other Threads in the MS SQL Forum
- Previous Thread: Do uncompression of disk drives affects my Database?
- Next Thread: database won't give correct permissions
