Exporting/Importing Objects from SQL 7.0 to SQL 7.0 
Author Message
 Exporting/Importing Objects from SQL 7.0 to SQL 7.0

Help,
We recently upgraded our system from 6.5 to 7.0 and had problems with software
called Proacta (now called Niku).  They gave us no help even though they wrote
the software.  We are tyring to import/export objects from SQL 7.0 to another SQL
7.0 machine.  We just want to copy the tables to the new machine and were
wondering how this exactly works with the options (triggers, indexes....)  IF we
don't check the triggers option what will happen to the data to the system we are
copying to.  What will happen with the data on the new machine?  Will it work
without copying the triggers?  Please HELP!!


Tue, 06 May 2003 03:00:00 GMT
 Exporting/Importing Objects from SQL 7.0 to SQL 7.0

I can't see why not.

I presume you are scripting out the table,triggers and indexes and then
BCP ing the data in OR
using DTS

Allan



Quote:
> Help,
> We recently upgraded our system from 6.5 to 7.0 and had problems with
=
> software=20
> called Proacta (now called Niku).  They gave us no help even though
they =
> wrote=20
> the software.  We are tyring to import/export objects from SQL 7.0 to
=
> another SQL=20
> 7.0 machine.  We just want to copy the tables to the new machine and =
> were=20
> wondering how this exactly works with the options (triggers, =
> indexes....)  IF we=20
> don't check the triggers option what will happen to the data to the =
> system we are=20
> copying to.  What will happen with the data on the new machine?  Will
it =
> work=20
> without copying the triggers?  Please HELP!!

--

Allan Mitchell
MCSE

Sent via Deja.com http://www.deja.com/
Before you buy.



Wed, 07 May 2003 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. importing a SQL Server 7.0 database to a SQL Server 7.0 database

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

3. SQL SERVER 7.0 DTS (IMPORT/EXPORT)

4. Problem while importing/exporting data on SQL Server 7.0

5. SQL 7.0 Install on W98 - cannot import or export data

6. Export/Import Binary Fields SQL 7.0

7. Importing and exporting from a procedure SQL server 7.0

8. Import/Export & SQL 7.0

9. Importing and exporting data in sql server 7.0

10. dts error while importing or exporting a database between 2 SQL 7.0 Server

11. SQL 6.5 / 7.0 import/export

12. Problem while importing/exporting data on SQL Server 7.0


 
Powered by phpBB® Forum Software