Calguns.net  

Home My iTrader Join the NRA Donate to CGSSA Sponsors CGN Google Search
CA Semiauto Ban(AW)ID Flowchart CA Handgun Ban ID Flowchart CA Shotgun Ban ID Flowchart
Go Back   Calguns.net > GENERAL DISCUSSION > Technology and Internet
Register FAQ Members List Calendar Mark Forums Read

Technology and Internet Emerging and current tech related issues. Internet, DRM, IP, and other technology related discussions.

Reply
 
Thread Tools Display Modes
  #1  
Old 07-11-2019, 8:09 AM
harbormaster's Avatar
harbormaster harbormaster is offline
Member
 
Join Date: Jun 2017
Location: Marina on the Delta
Posts: 283
iTrader: 2 / 100%
Default WTB Network or Cloud

My employer uses quickbooks pro and the migration to an online quickbooks isn't in the cards it just doesn't seem to have the capacity as that which we use loaded on our server. Our server is old. It needs to be replaced. We use three programs:

Quickbooks
A proprietary database application on Microsoft.net
Office Pro including most of the applications.
That is pretty much it.

We are interested in seeing if we can copy and run the database application to a cloud base program like Azure and then host quickbooks and Office on our desktops.

So I'm in Stockton area and looking for an IT pro to help me save some money and get this done? Anyone here capable? It seems like we're too small an operation for the IT companies around.
Reply With Quote
  #2  
Old 07-11-2019, 8:28 AM
Robotron2k84 Robotron2k84 is offline
Senior Member
 
Join Date: Sep 2017
Posts: 790
iTrader: 2 / 100%
Default

Cloud won't solve your problems. Just buy a new server and migrate.

Cloud is:

Expensive
Time shared
High latency
Slower than on-premises
Harder to manage
Open to additional security vulnerabilities
Requires a VPN to host a DB off-premises
Is really only a benefit if you want to virtualize a whole data-center's worth of equipment for a website or other large application.

Cloud only makes sense in a limited set of circumstances that mostly require very high uptime, flexible capacity and paying for usage-based service (which can get very expensive per month on a DB-sized instance running hot).

Good luck
Reply With Quote
  #3  
Old 07-11-2019, 9:21 AM
vino68's Avatar
vino68 vino68 is offline
Member
 
Join Date: Jul 2016
Location: Los Angeles
Posts: 389
iTrader: 0 / 0%
Default

Quote:
Originally Posted by Robotron2k84 View Post
Cloud won't solve your problems. Just buy a new server and migrate.

Cloud is:

Expensive-- Yes and no.If you Capex vs Opex, maybe. And depends on current spend of your IO.
Time shared- No. You can have reservations and/or create your own VPC.
High latency- Maybe. That depends on your circuit and the peering agreements with your WAN provider.
Slower than on-premises- Possible but depends on your circuit and type of data.
Harder to manage- No, easier for many of us that know what we are doing. AWS has been around for almost 20 years.

Open to additional security vulnerabilities- What isn't.
Requires a VPN to host a DB off-premises- Not necessarily.

Is really only a benefit if you want to virtualize a whole data-center's worth of equipment for a website or other large application. A whole data center is relative. Many startups use AWS or Azure for lower startup Capex expenses. They do not have any where close to what I would consider a "whole data center."

Cloud only makes sense in a limited set of circumstances that mostly require very high uptime, flexible capacity and paying for usage-based service (which can get very expensive per month on a DB-sized instance running hot). This is true to an extent, there are many variables and conditions. Far too broad of a statement.

Good luck
I have made notes in bold bases on experiences.

Last edited by vino68; 07-11-2019 at 9:30 AM..
Reply With Quote
  #4  
Old 07-11-2019, 10:04 AM
Robotron2k84 Robotron2k84 is offline
Senior Member
 
Join Date: Sep 2017
Posts: 790
iTrader: 2 / 100%
Default

Without getting into the weeds too far, I've run (managed and developed) private clouds based on ESX, KVM, Xen, Docker, Kubernetes, Chef, and a whole smattering of third party tech, including virtulized switching and net on net topologies. I've spec'd hardware for running 1000 instances per host and the storage required. I have a bit of experience.

My 30 second read of a single application (a database) migrating to the cloud for supposed cost savings and ease of maintenance doesn't add up for the reasons mentioned.

The cost structure of AWS et al. is cheaper only if you compare it to typical leases for premesis or DC equipment, the accounting necessary and the myriad fees associated with access, transit and maintaining your stack.

If you are on-prem and have a single stack, rarely, if ever do the numbers work out in your favor.

As for security, when you have more technology and products interacting, the exposure goes up geometrically. Do you get indemnification for breaches through the provider's network stack or hypervisor exploit?

As for manageability, I agree, with the right skill set it can be easier, but templatizing server builds and application deployment is not trivial and utterly unnecessary for a single DB.

In the OP's situation, please list the benefits of going to a cloud-based model.
Reply With Quote
  #5  
Old 07-11-2019, 10:04 AM
harbormaster's Avatar
harbormaster harbormaster is offline
Member
 
Join Date: Jun 2017
Location: Marina on the Delta
Posts: 283
iTrader: 2 / 100%
Default

^^^^
Learning thank you
Reply With Quote
  #6  
Old 07-12-2019, 8:05 AM
Dragunov's Avatar
Dragunov Dragunov is offline
Senior Member
 
Join Date: Dec 2008
Location: TEXAS and FREEDOM!!
Posts: 1,468
iTrader: 0 / 0%
Default

Quote:
Originally Posted by harbormaster View Post
My employer uses quickbooks pro and the migration to an online quickbooks isn't in the cards it just doesn't seem to have the capacity as that which we use loaded on our server. Our server is old. It needs to be replaced. We use three programs:

Quickbooks
A proprietary database application on Microsoft.net
Office Pro including most of the applications.
That is pretty much it.

We are interested in seeing if we can copy and run the database application to a cloud base program like Azure and then host quickbooks and Office on our desktops.

So I'm in Stockton area and looking for an IT pro to help me save some money and get this done? Anyone here capable? It seems like we're too small an operation for the IT companies around.
Lots of good responses here. MHO, is that "The Cloud" is just a fancy term for "Someone ELSE'S computer". Do you REALLY want to trust your data to "someone else's" computer?

I'd think LONG and HARD about that one.
Reply With Quote
  #7  
Old 07-12-2019, 8:26 AM
castgold's Avatar
castgold castgold is online now
Senior Member
 
Join Date: Feb 2012
Location: SoCal
Posts: 1,325
iTrader: 21 / 100%
Default

Why not just build a new robust server and sync the data?

Sent from my SM-G965U1 using Tapatalk
Reply With Quote
  #8  
Old 07-15-2019, 9:54 AM
the86d's Avatar
the86d the86d is offline
Calguns Addict
 
Join Date: Jul 2011
Location: Away from large terrorist targets..
Posts: 7,323
iTrader: 3 / 100%
Default

The Title of this thread reminds me of all corporate e-mails "subjects" I get from people, either click-bait, half-arseyness, or spam is what they appear to be out the gate. "QuickBooks: cloud or other" might be a better, more functional Title...

There is a reason Title is there, and it isn't for typing vague blankets...
__________________
Those who know Linux and use it daily generally find iPhruity Apple products useless...

Last edited by the86d; 07-15-2019 at 10:00 AM..
Reply With Quote
  #9  
Old 07-15-2019, 7:54 PM
anelson anelson is online now
CGN/CGSSA Contributor
CGN Contributor
 
Join Date: May 2019
Posts: 30
iTrader: 0 / 0%
Default

Quote:
Originally Posted by harbormaster View Post
My employer uses quickbooks pro and the migration to an online quickbooks isn't in the cards it just doesn't seem to have the capacity as that which we use loaded on our server. Our server is old. It needs to be replaced. We use three programs:

Quickbooks
A proprietary database application on Microsoft.net
Office Pro including most of the applications.
That is pretty much it.

We are interested in seeing if we can copy and run the database application to a cloud base program like Azure and then host quickbooks and Office on our desktops.

So I'm in Stockton area and looking for an IT pro to help me save some money and get this done? Anyone here capable? It seems like we're too small an operation for the IT companies around.

I've had a lot of experience migrating ERPs (GreatPlains -> Netsuite, etc). I would recommend getting out of using an "old version of quickbooks" on-prem. You're going to run into issues long-term.

I'm not sure why you couldn't migrate the data to QB Online. You should be able to migrate all the customers/vendors, SOs, etc with batch export/imports. It will definitely take some time / testing.

Some business/operations are tougher to migrate than others.. For example if you're in the business of selling items that don't need fulfillment records (software sales or services for example that don't have serialized inventory) - then it's easier. If it's operationally heavy with serialized items then there's going to be a lot more to move.

You could also, depending on the business, migrate over by moving over the GL totals and not all of the historical data over time. Maybe just the header amounts per month instead of all the individual records from each month for example.

For office, i'd recommend using office365 if you aren't using it already.

For the proprietary DB application, that could be put into a virtual machine or a dedicated machine and kept on-prem. I wouldn't spend money putting it in the cloud -- unless you're needing to provide others access to it remotely (e.g all the people that access that application aren't in the same office/location)
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT -8. The time now is 8:09 PM.




Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Proudly hosted by GeoVario the Premier 2A host.
Calguns.net, the 'Calguns' name and all associated variants and logos are ® Trademark and © Copyright 2002-2018, Calguns.net an Incorporated Company All Rights Reserved.
Calguns.net and The Calguns Foundation have no affiliation and are in no way related to each other.
All opinions, statements and remarks made by Calguns.net on this web site and elsewhere are solely attributable to Calguns.net.