Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Rolodex programs

Posted on 2014-03-03
6
Medium Priority
?
269 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
The top UI technologies you need to be aware of

An important part of the job as a front-end developer is to stay up to date and in contact with new tools, trends and workflows. That’s why you cannot miss this upcoming webinar to explore the latest trends in UI technologies!

 

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 2000 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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

721 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