Migrating from dbase to SQL

[petrovlis]

I have Goldmine 6.7 Dbase version and like to switch to a
SQL system,like ACT! 2007 in order to be more flexible in future,and Vista comptatible.I have now ACT 2007 standard
with the simple {built in "Express" sql server)1-5 users version. But I was told this is the bottom, better the ST
version 30-100 user for large +100.000 addresses handling.

I have some programming experience,so think I can manage
new SQL system

How to begin ? What standard program ? What book for beginners??? Sql for Dummies ??

I have large address files. and one/two users only,from
ONE/two machines.
Do I need Small Business Server ??
How to start up a simple database with relations.?

Thanks for any hints and help.
William

 

[AlexCuse]

First thing you could do is read this document on database design:

http://www.r937.com/relational.html

Second thing, here is the forum link for SQL Server Programming:
forum183

And here is the forum link for SQL Server Setup
& Administration:
forum962

You will see that those forums have MANY more members than this one, which will help your chances of getting a response. They are also more appropriate for your subject matter. Data Transformation Services are also not supported past 2000, and SQL Express does not even support their replacement (SSIS). So most of your imports will need to be done to your new database through t-sql queries or a front end like MS Access linked to your server.

I hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[GLComputing]

But I was told this is the bottom, better the ST version 30-100 user for large +100.000 addresses handling."

1. Is there a reason you don't want to just use ACT!? Why attempt to re-create something already available?

2. There are three versions of ACT! 2007 (not including Web or PDA):
a) Standard - SQL 2005 Express. Limited to 9 users (Microsoft licensing)
b) Premium EX - SQL 2005 Express. No user limit and includes work group features like teams and customisation of Sales Ops, etc
c) Premium ST - SQL 2005 Standard. The only advantages of ST over EX is in scalability if you have the hardware - ie it will use multiple processors, more than 1GB RAM and allow >4GB databases. No feature change from EX.
If your server doesn't have >2GB RAM or multiple processors, ST won't be an advantage over EX.

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au