General discussion

Locked

Which Database would be best

By J. lovett ·
HI,

I have developed a large access DB for a company. When the project started they were just one office. Now they have three offices and remote users. Access is definatley not the best solution for this type of environment. I was wondering what suggestions where out there for databases that support remote access efficiently without having to replicate. The company does have a T1 in the main office and most of the remote users have a broadband type connection and a few have dial up only. m Any ideas would be appreciated

Thanks In Advance Jim

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Which Database would be best

by Jay Eckles In reply to Which Database would be b ...

I think any major DBMS would work, but for ease of conversion, SQL Server might be a good choice. Converting from Access to any other DBMS might be a bit of a challenge.

Good luck.

Jay Eckles
www.jayeckles.com

Collapse -

Which Database would be best

by J. lovett In reply to Which Database would be b ...

The question was auto-closed by TechRepublic

Collapse -

Which Database would be best

by Shanghai Sam In reply to Which Database would be b ...

I use the D3 database from Rainingdata. www.rainingdata.com
This is a database built on the 'PICK' model. The version we have runs on NT, but you can purchase a version that runs on any major operating system.
We have a few remote users who dial in to the server. The database has the ability to work within web pages also, so instead of dialing long distance, your users can access local internet connections and proceed to the proper page. This system is priced very reasonably too. Your biggestexpenses with this system will probably come from having to hire PICK Programmer(s).
I have performed numerous data conversions from access/excel/csv/dbf using a package called 'wIntegrate'. So conversions can be done by the right person with little or no pain.
I haven't worked with any of the other database models, so I can't give you a comparison, but I hope this helps. Good Luck.

Collapse -

Which Database would be best

by aryana79 In reply to Which Database would be b ...

Jim-

I think any major DBMS is goig to work fine for sure. Now if you are worried about the ease of converting the system, I have heard that going from Access to SQL Server is really not that difficult and I can't imagine it would be since they are Microsoft products. Also I don't believe SQL server is very difficult to use. Now Oracle is of course always great. Converting from Access to Oracle is a bit more difficult. I have done that before. It's not super hard though. And if you know basic database modeling and database principles, you should be fine. Again I think any major DBMS would work. Just choose something that will be easy and fun for you to work with. Well good luck to you.

Aryana

Collapse -

Which Database would be best

by J. lovett In reply to Which Database would be b ...

The question was auto-closed by TechRepublic

Collapse -

Which Database would be best

by J. lovett In reply to Which Database would be b ...

This question was auto closed due to inactivity

Back to Web Development Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums