DTS with SQL 7.0 Desktop and SQL 7.0 Enterprise 
Author Message
 DTS with SQL 7.0 Desktop and SQL 7.0 Enterprise

We have been developing using SQL 7 Desktop on NT Server 4.0

We brought a new (production) server running SQL 7 Enterprise on NT Server
Enterprise 4.0

We want to put our development data onto the production server, to include
tables, repository data, indexes, and OLAP cubes... and figured DTS was the
best way to accomplish this.

Unfortunately, we found that we can't use DTS to transfer data from our
development platform to the new production server.

One solution... to blow away the development box and install NT Server
Enterprise... won't work because we have a mainframe emulation package that
takes about 2 weeks to properly configure.

Microsoft has provided few palatable options.

We would appreciate hearing from the experts on this quandary.

Thank you!



Mon, 08 Apr 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Technical Difference between SQL 7.0 Standard and SQL 7.0 Enterprise

2. Upgrade from SQL 7.0 standard to SQL 7.0 Enterprise

3. SQL Server 7.0 vs SQL Server 7.0 Enterprise

4. DTS Export/Import Wizards: Server 7.0 to Desktop 7.0

5. SQL Sever 7.0 - Desktop Enterprise Manager

6. SQL 7.0 Desktop Edition vs Enterprise

7. SQL 7.0 desktop and standard DTS,replication

8. Difference between SQL Server 7.0 and 7.0 Enterprise Edition

9. SQL 7.0 DTS package errors after change with Enterprise manager 2000

10. DTS from SQL Desktop to SQL Enterprise

11. Help - migrating from SQL 2000 desktop to SQL Server 7.0

12. SQL 6.5 Replication To SQL 7.0 Desktop


 
Powered by phpBB® Forum Software