Installing Server and in my office

[rtln17]

Hi all

I need some help from all the expert here regarding migrating my POS/inventory software from the hosting centre to my server in my office.

My situation is:

we have a web base sofware that we process our company POS and inventory like issue Delivery Order, Invoicing and checking of inventory balance. Due to the high cost of hosting and maintenance cost to the IT firm that did the software, we would like to host all the data and the program in a server in our office. After migrating the sofware and data to our server, we will not be able to log into the inventory system over the internet as we do not intend to host it over the internet. So in another words, it serve only intranet.

My question is, once i get a server, we will get the IT firm to migrate all the data and software to our server. Is it as easy any just copy the whole program from the hosting place and copy into our server harddisk? So get the server in our office to assign a static IP address so that we can log into the POS/inventory system from our office computers which are all network already? How do we go abt setting the IP address to that once we key in the IP address on our explorer, it brings us to the POS/Inventory Homepage which is the log in page.

Is the above mentioned possible so we do not need to pay for IP hosting fee and maintenace fee? Is it easy to do the migrating and set up the server so that we can access the software?

Thank you very much in advance!!!!

[voldermord]

My question is, once i get a server, we will get the IT firm to migrate all the data and software to our server. Is it as easy any just copy the whole program from the hosting place and copy into our server harddisk?

A: I assume its web base and so it uses MYSQL or MSSQL and if so you cannot just copy paste, must backup and restore. The webserver files (htdocs/ www' home etc) can copy paste. The new database must be setup exactly though, same password, user else must change more things.

So get the server in our office to assign a static IP address so that we can log into the POS/inventory system from our office computers which are all network already? How do we go abt setting the IP address to that once we key in the IP address on our explorer, it brings us to the POS/Inventory Homepage which is the log in page.

If the web is using port 80, just assign an IP address (static) under network properties > tcp/ip (v4) and assign a static ip address with the same subnet from the other pcs and same first 3 digits ie 192.168.1.x and probably 255.255.255.0 if your company doesnt have a huge network and subnetted it.. Gateway is your router ip if you want it to access internet. Than just go any pc and in IE/FF type 192.168.1.x. If you are more tech savvy can even configure like person type it-db it will go to the webby str8. If you have your own Network personel even easier.

Is the above mentioned possible so we do not need to pay for IP hosting fee and maintenace fee? Is it easy to do the migrating and set up the server so that we can access the software?

Possible and easy with basic knowledge :s12:

[chunmeep]

Networking geek here. Would do all that for you for half the price of whatever IT firm charges you :) pm me

[xbcloud]

Networking geek here. Would do all that for you for half the price of whatever IT firm charges you :) pm me

will do for you whatever price above - 10% ;p

[phuque99]

if your job security depend on successful migration, i suggest you get proper professional quote and liability signed with a system integrator. any daichi won't lose your job.

[jkyhon]

if your job security depend on successful migration, i suggest you get proper professional quote and liability signed with a system integrator. any daichi won't lose your job.

FULLY AGREED!
Dun act smart alec in the end loose your job. Company should cut cost during this tough time, but all the problem arises during such migration would cost operation problem and eventually business lost, not worth it.....

[chunmeep]

I was an intern that setup BATA's networking system/billing system. So. well... yeah if you want to be absoutly sure and waste that 2000-3000sgd on useless liability coverages then sure :p

[rtln17]

hi voldermold

thanx for the recommendations. sounds like quite tough as i am not tech savvy. anyway i am happy that we can migrating into our own server without relying on my current IT firm to host. Although my program is website base written using asp i think, but at this moment we do not need to utilise the web base function yet (which is we can log in from anywhere as long as there is internet) so can cut cost at this kind of economy.

u also mention that we have to align the database with with those log in username right? and also create a static IP address so that we can intranet and simply type the static IP and the log in page will appear in our office computers?

btw...any simple server to recommend? and how much does it cost?...also which platform and OS willbe the best for long term usage?

thanks alot...

[phuque99]

I was an intern that setup BATA's networking system/billing system. So. well... yeah if you want to be absoutly sure and waste that 2000-3000sgd on useless liability coverages then sure :p

Another way of putting this, are you wasting $5 for your plate of char kuay teow or your cup or starbucks when you can cook / brew them yourself after asking around? Or would you spend the money and spend the time in a more productive manner? No right or wrong here, just opinions and what works for you :D

[misato]

May i remind you that implementation and maintenance thou sounds closely related is hardly the same thing.
You maybe be good and setup the initial phase but will you be there always to fix any issue that comes along? Some money are worth saving, but some don't. The only time to prove their worth is when something happen.

In-house hosting of server has it perks and risks. You can save on the hosting cost, but do you have that someone who can maintain it for you, run your backup and when things go wrong able to restore your data? When you host your own equipment, vendors will always push the problem to your own equipment and using that excuse to charge you like crazy or say sorry, its beyond my means cause you never buy our service etc etc..

So end day, the answer to this question is how much is your data worth.

[geckoSG]

TS, consider let your vendor do it. After that, get them to give you the
documentation for setup, etc. For maintenance, then look for other firms.
Why risk your data? Your vendor may charge you sky high later if anything goes
wrong. Worth the risk? You think for yourself bah.

I've seen too much of companies trying to save on migration, etc to have their
own pockets burnt deeper than they should.

And I do hope freelancers take responsibility in their assignments when they
takes up the tasks. Been seeing alot of bad freelance implementation in my IT
career to date...

There are good ones out there, but rare.

To Freelancers...

And please, do not spoilt the market. Your daily JOB SALARY will be affected
by the pricing you offer out there as Freelance. What goes around, comes
around back to you at the end of the day. Its not your boss are not willing
to pay you higher salary. Its the pricing that freelancers picks up the job
that causes your salary to DIP to rock bottom. Think twice...

:o

[masayuki]

geckoSG, i agree with what you have posted.

I have been very frustrated by the quality of work by some freelancers who think that they are qualified to do all kinds of deployment just by being part of a group of junior engineers who set up some "big" project.

I'm a network consultant, but i do systems as well. There is nothing more frustrating then to go for a meeting at the customer's place and realize that their "cost-cutting" measures of hiring unqualified freelancers has managed to screw the whole network upside down.

I do freelance sometimes but it is usually to cover for another company who has had gotten the contract but cannot go ahead with it due to some reasons. I normally take half the contract value.

TS, go with your vendor, at least someone can take responsibility for the migration and confidentiality of your data.

[pcteo]

hi voldermold

thanx for the recommendations. sounds like quite tough as i am not tech savvy. anyway i am happy that we can migrating into our own server without relying on my current IT firm to host. Although my program is website base written using asp i think, but at this moment we do not need to utilise the web base function yet (which is we can log in from anywhere as long as there is internet) so can cut cost at this kind of economy.

u also mention that we have to align the database with with those log in username right? and also create a static IP address so that we can intranet and simply type the static IP and the log in page will appear in our office computers?

btw...any simple server to recommend? and how much does it cost?...also which platform and OS willbe the best for long term usage?

thanks alot...

TS, it doesn't sound quite right, if u are not tech savvy in this area. and u mention it sound tough.
I think is not very simple data copy, bcos, from ur describe u need server setup, database configure, etc.
u will need IT person to do, not only the setup, implement, but also maintenance.

does that cost less than outsource hosting ?
unless, u already have a IT person in office, that can resolve issue, together with u. othrwise it may be better to let ur current IT firm do it,
Or the other way to do a small test first, b4 u decide.