Solved

Rolodex programs

Posted on 2014-03-03
6
247 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
  • 3
  • 3
6 Comments
 
LVL 52

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 52

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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

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 52

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now