SQL Express Vs SQL Standard For Hotel Booking Web App...
Nov 28, 2006
We are developing a new online booking system with asp.net and looking for optiosn for the data store. Currently the PHP applciation utlizes MySQL but we would like to use SQL Server in the rewrite.
What limitations would we run into with Express over Standard for such a system? Is the 4GB size limit and advanced SQl features such as replication, etc the only differences? We are looking for something to run on a dedicated or VPS based Windows server that will only be running our app and database. System is an online hotel type booking system with approx 7000-12000 transactions per month which may double in the coming year.
Express certainly has a cost advantage but we don't want to run into issues with this version if there are any we should watch out for.
I want to develop a website with a database of hotels from 5 diferent countries. I want the user to be able to write into text fields or select from bullets or any other better select option , the following information:
destination country destination city rooms date of staying (because rates changes depending on the season)
once with the information, the site will display a list of hotel options from the countrie's city selected with pricing info Here is a sample of what would appear:
extra nights $100 / $69 / $62 / $32 ----------------------------------------------------------
Im not planning to use online payment, or online ordering, I just want the info like the one above from all the hotels option, then if you are interested in a hotel you send an email to the company with credit card info and desire hotel and dates, so the web page would be just for information purposes. if you think about it it shouldnt be that hard, (or at least thats what I think because it doesnt have a lot of interactivity
I would like to make the website so that my client could easily make changes to the hotel prices or names in the future.
Now to the questions:
I have been told to use Mysql and php (I do know html, and ive done webpages in the past) so i started to learn sql, i think its pretty clear and logic how it works, also I was told to download apache, which if im not wrong installs php and mysql and configure the server in your computer? am I right? I have been trying to find a book for php, but I dont know exactly which one to get, so:
1. can you recomend a specific book on php wich covers something like this?
2. By learning sql, I should have no problems applying my knowledge to mysql? ( i know that some functions are different)
3. How does php manipulates mysql?
4. Does apache installs php and mysql and configure my computer to be a server or i have to download php and mysql separetely?
5. if apache does all that, where do i start developing? where do I write the php code so it displays in apache?
6. where do I write the mysql tables and code?
7. For a website to contain mysql and php do you need a special hosting service? what do I have to consider when looking for the hosting provider, are they expensive?
I dont expect all my questions to be ansered, I would be gratefull if only one would be answer, I know it sounds as if I want everything solved, but trust me, that ive been trying to learn as much as i can. The reason I am posting this is because i have 4 more days to decide if I accept the job or not, so I want to be sure that I am going to be able to do this. then I will have 6 months to finish the website, I am a student and I need money to pay my school, Thank you in advance and if someone is still reading THANK YOU AGAIN !!!!!!!!!
ps, I was even planning to give money for the person who helps the most....has this been done before? jejej
Can anyone out there help me? I am developing a hotel management system. I am trying to come up with a way of identifying all the residents with outstanding payments.
In order to do this I have designed a session table where the session for each guest are staored. Each of the sessions has a session balance, and when a guest make a payment, this balance is then incremented.
For every day that passes I would like to subtract the hotels rent from the session balance automatically. Is this feasible, and how can this be done.
I would be very greatful to anyone who would be able to help me or give me advice, coz at the moment I am clueless.
I am building a small app that will display availability data for properties. I have a calendar that displays the dates for a whole year in month rows with each days colour representing the availability status, i.e. booked, on hold etc. My question is about how to store these dates in the db. At the moment I have the table below: TABLE Availability [PropertyID] [int] NOT NULL , [StatusID] [tinyint] NOT NULL , [StartDate] [smalldatetime] NOT NULL , [EndDate] [smalldatetime] NOT NULL I was planning on having four status's for any given date, unknown, available, on hold or booked. Displaying the dates has proved pretty simple but updating availability means I would need to query the db to see if any of the dates overlapped, I would then have to add the new date range/status as well as change any date ranges that overlapped, either in the sp or in the code and this is what made me wonder if there was a better way. Does this sound a reasonable approach? Any advice or pointers would be greatly appreciated, This is the first time I have had to store date ranges and I want to make sure I am doing it right.
We are in the midst of developing/upgrading an online store in ASP.net 2.0 that typically gets about 100,000+ hits per week and we are considering MS SQL 2005 Express as its free to use. My question is how will MS SQL 2005 Express support so many concurrent visitors and will MS SQL 2005 Standard / MS SQL 2005 Workgroup be a better option as far as performance?
Hello, can I run the express edition on my desktop and test web site with it, but then deploy the same app to my webhost and have it use SQL2005 standard? (They don't support the express edition.) I'm new to SQL2005 and am curious. In fact, I still don't totally understand if express is installed or just a file like access. :) Thanks! Stephen Rylander
Hi friends, I want to install Visual Studio .NET 2005. I've seen that there are several questions about upgrading from SQL Express to Standard edition, so I though that if it's possible, first I install SQL Server Standard and then during installing Visual Studio I don't install SQL Express that is by default is installed, but I don't know is it possible to introduce Standard edition instead of Express edition to Visual Studio? and if it's possible, how can I do it? would you help me? thank you in advance.
Good day all, I apologize if this is somewhere and I didnt search enough. I currently have a nice internal application that provides company wide visibility into some key data. Im now being asked to create some reports from an Oracle 9i platform in SQL 2005 Reports Server. However the ORACLE data extension is not allowed in the express edition so Im stuck for a moment. I would like to do an inplace upgrade of my existing MS SQL server from 2005 express to 2005 standard. However, I am a little concerned it might break some things. Has anyone achieved this with great results, a mixed bag, or totally blown up their server? I would like to know the good, bad and then down right ugly details of this if there are any. I am currently running a windows 2003 server with MS SQL 2005 Express (Advanced edition to get the Report Server in there). Is it at all possible to do an inplace upgrade from Express to Standard edition and not lose any connectivity permissions, reports server and so on? Would there be 2 seperate installations one for SQL Server and another for the Report server? Thanks in advance for all your replies, Ive used this forum on many occasions and learned alot along the way. I hope someone here can help.
I have SQL Server 2005 Express that was installed with SharePoint Server 2007. I'm trying to upgrade it to SQL Server 2005 Standard edition and it gives this "Edition Change Check (Warning)" message:
"To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter."
I tried "setup skuupgrade=1" from the command prompt, but it's giving me the same message.
Can someone tell me how to correctly make the upgrade?
I have installed VS2005 with SQL Server Express. I used this setup for about a month. Now i have SQL Server Standard Edition. I am confused about how to swap them over. Everything is running on the same machine - i just want to use SQL Server Standard instead of SQL Server Express. Can anybody explain how to get this up and running? Also will membership, profiles and the other built in providers work with this? - Thanks for any help! - Callam
I'm considering upgrading from MSDE 2000 to Express 2005. Before I do that I need to know if my linked server dependant scheduled jobs will continue to function properly.
Here's my current configuration:
I have a local SQL Server 2000 Standard edition box linked via IP address to a remote MSDE 2000 SQL Server. This link uses SQL authentication.
I want to upgrade the remote MSDE server to 2005 Express. Will my local 2000 SQL Server link successfully with a 2005 Express server?
Also, I have 2000 Developer Edition on my machine and am using Enterprise Manager where I have registered the remote MSDE so I can easily manage the server. Will I be able to register a 2005 Express server or will I need to upgrade my developer machine to 2005? If I do upgrade my developer machine, will I still be able to register the 2000 Standard Sql Server?
If there are any other issues with running a mixed environment like the one described here, please speak up! I want to make an informed decision.
I am working with someone in a different state. He is using SQL Express, I am using SQL standard. He has created a large DB that i need a copy of on my machine.
Is there a way for him to make a copy of his DB so it can be placed on our FTP site for me to download?
I've got some applications which need .NET 3. And since theoretically .NET3 is using .NET2's runtime (CLR), I'm told that applications for .NET2 should work in .NET3 as well. But I would still like to ask to have a confirmation:
Can SQL 2005 Standard edition and Express work with .NET 3 or .NET 3.5? Has Microsoft tested this and can confirm this?
I'm not a developer and would like your input to compare against what a sales rep is telling me.
I'm managing a small web project that will have a database with a max of 20,000 records with less than 50 field each. It will be hit by anything from 200 to 500 people in a day (max) via Internet connection from all over with all sorts of speed.
The users will select less than 50 filters to obtain the results of the info they are looking for among the 20000 records. Most users will only choose less than 10 filters per search.
That's all that the database will do...seems to me enterprise is way too much, but since I'm not expert, need one of you to help with your input.
I've got some applications which need .NET 3. And since theoretically .NET3 is using .NET2's runtime (CLR), I'm told that applications for .NET2 should work in .NET3 as well. But I would still like to ask to have a confirmation:
Can SQL 2005 Standard edition and Express work with .NET 3 or .NET 3.5? Has Microsoft tested this and can confirm this?
I have installed SQL standard Edition in my computer for one project. We want to kick off a new project, and intend to use SQL Express, Will anybody advise me whether I can install SQL express when SQL Standard Edition is there? or I need to remove SQL standard Edition first and install SQL express?
I've got some applications which need .NET 3. And since theoretically .NET3 is using .NET2's runtime (CLR), I'm told that applications for .NET2 should work in .NET3 as well. But I would still like to ask to have a confirmation:
Can SQL 2005 Standard edition and Express work with .NET 3 or .NET 3.5? Has Microsoft tested this and can confirm this?
Hi, For the SQL Express & Std Edition have rows limited.... I have try convert a 3,667,345 rows data into SQL Sever can the SQL Expree 2005 and SQL Std 2000 support this volume of rows???
I want to Upgrade my express instance "Officeservers" to standard. I have installed Sql Server 2005 standard, but the MOSS 2007 installs default Officeservers to express. The reason to upgrade is to use the maintenance plans to backup the instance. I have a report server on a different instance (standard).
Do I upgrade with SKUUPGRADE=1 and this is all ? Do I need to run sp2 after this and does this affect my report server ?
We are needing to script to find out if our servers have a full version of SQL Server installed or if it is just SQL Express that is used by one of our backup software vendors. How can we do this? Currently, we are having to go into each server and look at the SQL console. Anything that someone can suggest would be greatly appreciated as we have hundreds of servers to go through. Thanks much in advance. Cathy
Having some problems Upgrading from SQL Express 2005 SP2 to SQL 2005 Standard. I'm getting the following:
Name: Microsoft SQL Server 2005 Express Edition
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.
Pretty sure that I have to have SQL 2005 Std w/SP2 but I don't have a CD with it on. Is there a way that I can create one so that I can upgrade the SQL Instance In-Place.
I am hiring a server at a hosting company. This server contains a dozen websites that i made and they all have their own database. Well, i received a message from my hosting company that they go to remove the SQL 2000 Standard and replace it by SQL 2005 Express. What do I have to think about that? Can this give database connection problems?
Can the SQL Server 2005 Management Studio interact with local SQL 2005 Express databases. So can we use one management tool for both our server (non-local) SQL 2005 Databases and our local SQL 2005 Express databases (That the developers have free reign over).
Hi all, i have standard edition of sql server, on a server hat doesnt have sql server standard would i be able to connect to it using my connection string. Or does the server has to have standard edition too. Is this same for express edition, and if possible to do this whats the difference between express connection string from standard edition thanks
