• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 845
  • Last Modified:

SQL Server 2008 R2 Express DTS - Can't Save Translation Routines

I am converting a number of SQL Server 2000 databases, with numerous tables, to SQL Server 2008 R2 Express. I just learned that one of the limitations with the express version is that one can't save the DTS translation tables and routines with the Express version. Given the number of databases, tables, table and field name changes and the need to update data between the two SQL Server formats during our development process, I need some type of DTS where the translation tables and routines can be saved.

Can anyone recommend a 3rd party DTS program?

Thanks for the help!
0
dwcummings
Asked:
dwcummings
  • 2
1 Solution
 
lluddenCommented:
You could use a 120 evaluation version of SQL 2008 R2 standard if you just need it long enough to do the transfer.  If you need it full time, it has to be more cost effective just to go with the full version of 2008 R2
0
 
dwcummingsAuthor Commented:
With the number of users we have and CALS we would need to purchase, it would cost about $6,000 for the standard version. I like your idea of using the evaluation version, but 120 day period is too short. We are developing a new front end and don't expect it to be in place for 6 months.
0
 
lluddenCommented:
The evaluation version of SQL is 180 days, which puts you close to the time frame you want.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now