Note 1: Job will be awarded to the best qualified lowest bidder.
Note 2: I am not a database or network professional at all. Otherwise i would do this myself. I state this so that you understand my vocabulary is that of a layman, not of a database pro. Thus, in cases where you could interpret something two different ways, use the laymans definition of the word.
Note 3: I am not married to Azure. If there is a different hosting solution with a MAJOR hosting provider (bluehost, hostgator, 1and1, dreamhost etc.) I MAY be open to using an alternate provider. Pricing and user friendliness will be heavily wieghted.
I have a piece of software that installs a local application and local DB using SQL Express 2005 . The installation EXE file also allows the option to install the DB on a remote server. When given the correct server address, DB name, username, and password, the software will "install" the DB on the remote server. I have a windows Azure 3 month trial account. I have set up a server and a DB on the Azure account, provided the address and login information to the software and attempted to do the remote install. It successfully logs into the remote server and appears to successfully complete "Installing Tables (Please wait, may take a few minutes)..." When it finishes doing that it attempts to begin "Installing Default Data (Categories)". At this point the program stops and I get the error "Invalid Object name 'Categories' "
A more complete discussion of this error and the steps i have tried to accomplish can be found at stack overflow here
I believe the maximum size of the database needs to be 4-5GB, based on support tickets within the developers support system.
The developer will not provide any support for remote database hosting other than on the developers own servers.
I will provide the trial copy of the software in question.
I will provide the login information for the Azure server.
You may (but it is not required) elect to sign up for the 30 day free trial of the software for your self, pay $1 on a credit card, and then you will have access to the developers support ticket network to view past questions and answers regarding remote database issue. If you do this i will reimburse you for the $1. I will not provide my login to the software website.
You may (but it is not required) elect to sign up for the 30 day $1 trial of the remote hosting of the database for your self, pay $1 on a credit card, and be able to test the performance of the database. If you do this i will reimburse you for the $1. I will not provide my login to the software website.
You will figure out how to get a fully functioning database into Azure that is completely transparent and compatible to the software in it's "Remote Database Install" state as if it were hosted on the developers own servers. The configuration will be at the lowest monthly cost possible for Azure hosting when the 3 month free trial runs out. I can pay the software developer ~$30 per month to host the database on the developer's servers and avoid all this hassle but i woudl like to lower the long term costs from the outset. My goal is a monthly hosting cost with MS Azure of $5 or less. $10 at the most.
This solution must be configured such as to take no more time to communicate and interface remotely with the database than is necessary with the developers hosting option.
You will provide me step by step instructions written in clear English so that a complete layman with ZERO DATABASE EXPERIENCE using free software tools could duplicate the database migration and installation if it ever had to be done again in the future.
You will provide me step by step instructions written in clear English so that a complete layman with ZERO DATABASE EXPERIENCE using free software tools can manually back up and restore the database to Azure.
Bonus: You will provide me step by step instructions written in clear English so that a complete layman with ZERO DATABASE EXPERIENCE using free software tools can install a script (written by you, i don't expect you to teach me programming) to automatically backup the database. (I'm not sure if this part is possible...)
Thank you for bidding on the job.
Skills: microsoft-azure, english, test