Solved

Rolodex programs

Posted on 2014-03-03
6
250 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Modal Popup Extender control 1 20
convert null in sql server 12 34
Whats wrong in this query - Select * from tableA,tableA 11 31
SQL Count issue 24 16
This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

809 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