Solved

Rolodex programs

Posted on 2014-03-03
6
266 Views
Last Modified: 2014-03-03
We have an Intranet that services as a Rolodex and runs some reports. It was created with ASP.NET and Visual Studio.Net and calls the information from a SQL 2000 database. We were going to upgrade our SQL 2000 database to SQL 2012 but we are finding out it is quite involved with the coding and we cannot get a hold of our programmer.

We wanted to find out if there are popular Rolodex programs that might be able to replace this functionality? Any assistance offered would be greatly appreciated.
0
Comment
Question by:regsamp
[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
  • 3
  • 3
6 Comments
 
LVL 53

Expert Comment

by:Scott Fell, EE MVE
ID: 39900347
Can you define the functions your current program does and what you use, what you need?

Have you considered office365 and using online exchange?  That should do everything you need

http://office.microsoft.com/en-us/products/microsoft-office-365-for-home-or-for-business-office-online-FX101825692.aspx?CTT=97
0
 

Author Comment

by:regsamp
ID: 39900355
We had not considered going down that route at this time. We run reports on Construction Permits, Client information retrieval such as name, address, phone number, ect and well as internal company information that an Intranet would run. Such as vacation times, ect.
0
 
LVL 53

Expert Comment

by:Scott Fell, EE MVE
ID: 39900370
What are the issue you have by upgrading the db?  Is your current system custom or off the shelf?
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

Author Comment

by:regsamp
ID: 39900389
Our current system is okay but we really need to upgrade our database as it is SQL 2000 and we are falling drastically behind. We have cost concerns as well as coding concerns upgrading as we are facing compatibility issues.
0
 
LVL 53

Accepted Solution

by:
Scott Fell,  EE MVE earned 500 total points
ID: 39900439
Are you or somebody in  your organization familiar with sql server?  If so, I would simply create a test environment  and start out first by upgrading from 2000 to 2008 http://blogs.technet.com/b/mdegre/archive/2009/07/21/migration-sql-server-2000-to-sql-server-2008.aspx  Since this is in a duplicated test environment, you are not touching your actual live database or files,  just copies.   The upgrade could be easier then you think.  

If that is too much for you, it would be best to consider hiring somebody to do this for you or look into an off the shelf product.   You may be able to do what you need using office365 where you keep your contacts in exchange and share files with sharepoint.  I am sure there are plenty of web based options for crm like https://www.salesforce.com or https://www.openerp.com/
0
 

Author Comment

by:regsamp
ID: 39900476
I am somewhat familiar with SQL but we have not done a migration before. We are trying to get a hold of the programmer that did our initial coding but cannot reach them. Okay, thank you.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…
Viewers will learn how the fundamental information of how to create a table.

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question