In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
Solved
Using a local database via web browser
Posted on 2012-12-28
I am converting a race timing service from a windows-based software to a web-based system. The goal is to run the service off of the database on the web server at a remote location. However if I am at a location where I can't access the remote server I would like to run it off of the local db on the machine I am using via a web browser and then upload to the server later. What are my options?
Thanks~
Thanks~
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
4
3
11 Comments
Active today
Write something the has a connection string to a database you can alter. Run it against localhost or a URL. Then you can work on importing records from one db to the main db. That's probably a separate app.
Active today
Your 'real' problem will occur when the internet connection goes down in the middle of your event, something that is very likely to happen if you are connecting wirelessly. You are probably better off keeping your Windows-based software and adding a routine to upload it to the web database after the event.
Active today
That sounds like a plan. Spend your time on sending that data to an aggregate web service that can display results and such. Leave the tracking as is.
So I am hearing that the way to do it is to run it against a local db and then periodically upload it to the server. I currently use connection strings for my remote db. I assume I would do something very similar to connect to a db on my local machine. Can I do it via my chrome browser if it is connecting to a db on the local machine?
Active today
IF you want a web front end, and you have windows 7 available, I'd start with installing localdb ( or full SQL express if you want) , and putting your site in IIS. Then you can use chrome or Firefox or whatever you want
Active today
A browser by itself will not connect to an SQL server. Browsers connect to web pages. Some kind of program is going to be required to do the database connection and formatting. To access it thru a web browser, you will also need a web server that supports your programming language.
I have full sql express on my server and my local machine. The web code is classic asp hosted on iis 7.0 on a remote server. Does that mean I am good to go? I will try to begin setting this up in the next couple of days and I don't want to bother folks once I accept a solution.
Ok so I guess what I am saying is how do I create a connection string to a local db. I already know how to run it against the db on the server....
Featured Post
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
- Microsoft Applications
- Windows OS
- Fonts Typography
- Web Browsers
- Microsoft Word
Shows how to create a shortcut to site-search Experts Exchange using Google in the Chrome browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site.
Launch the Search Engine Menu: In chrome, via you…
How to create a custom search shortcut to site-search Experts Exchange using Google in the Firefox browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site.
Launch your Bookmark Menu: Press 'Ctrl +…
Suggested Courses
Course of the Month5 days, 6 hours left to enroll
670 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.