×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

not sure what to go with

not sure what to go with

not sure what to go with

(OP)
The main feature we are looking for is to be able to move data from one database to another, Progress --> SQL Server.  I need to be able to update the tables in SQL Server and not wipe them out.  Would SQL Server 2005 Standard edition work for this, or do i have to go all the way to enterprise...would workgroup work for this?  I'm not sure and we need to make a decision soon.  Thanks for any help you can give me.

David Kuhn
------------------
www.davidpkuhn.com

RE: not sure what to go with

You can do this with any version of SQL 2005, or SQL 2000.

It can either be done with SSIS, DTS, or T/SQL.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible.  All it takes is a little research. (Me)
noevil
http://www.mrdenny.com

RE: not sure what to go with

(OP)
can anyone help with this.

David Kuhn
------------------
www.davidpkuhn.com

RE: not sure what to go with

It appears that you are correct Analysis Services does not come with Workgroup edition.

DTS appears to be included with the MSDE boxes that I've got, so I'd assume that it's available in Workgroup as well.

DTS is included for backworks compatabily.  DTS is slated for removal in the next version of SQL Server.  While you could use it, it isn't the best option to use with SQL 2005.

SSIS is totally different that DTS.  From what I've seen of SSIS there is a step learing curve from DTS.

You may want to keep in mind that the folks that post on these forums have regular jobs and late in the afternoon isn't the best time to get an instant response.

You should also probably wait more than 8 minutes before complaining that no one is helping you.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible.  All it takes is a little research. (Me)
noevil
http://www.mrdenny.com

RE: not sure what to go with

What I under stand your problem is that you need to Append data from a Progress DB to a SQL DB.  this is what SSIS is built for.  Etxtract from source (Progress), Transform the new data to remove duplicates, Load new records.  Getting a book on SSIS is probably your best bet on how to build it but yes it is possible.

Shoot Me! Shoot Me NOW!!!
                           - Daffy Duck

RE: not sure what to go with

(OP)
Thanks guys.  I'm sorry, if you look, i waited 1 day and 8 minutes.  So i should probably go with Standard Edition?

David Kuhn
------------------
www.davidpkuhn.com

RE: not sure what to go with

Yes SQL 2005 standard edition will work fine.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible.  All it takes is a little research. (Me)
noevil
http://www.mrdenny.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close