You have to make sure you don't select the default option of just copying
the tables and data during the DTS process. There is a screen with 2 or 3
options (after you've selected source, destination, and the tables I think).
Make sure you select the option that mentions copying all objects etc.
Instead of selecting - 'Copy tables and views from source', choose 'copy
objects and data'. You will have more control over what objects are to be
copied. This way your default values as well as primary key designations
will also get copied. Be careful though; with this method, it is quite
Here's what I do. I use the SQL script generator to build a script with all
my indexes constraints and defaults in it. I use it to create everything
EXCEPT the constraints (foreign keys) on the new blank DB. Then I run DTS to
import the data, then I run the constraints portion of the script. It
I have a table with 90,000 recs that I need to export into text files of
1,000 records each (our Quark extension won't take more records).
Is there a way to automate this procedure as opposed to me editing and
executing a DTS 90 times? Thanks!
This might sound dumb, but why not write
This is what I resorted to doing. CF is extremely slow at this though...
time to learn some PERL.
- Original Message -
From: Philip Arnold - ASP [EMAIL PROTECTED]
I have a table with 90,000 recs that I need to export into text files of
1,000 records each (our Quark extension won't
I'd export one gigantic file, then use grep or some similar tool to split
the file into many little ones.
-Original Message-
From: stas [mailto:[EMAIL PROTECTED]]
Sent: April 23, 2001 2:33 PM
To: CF-Talk
Subject: Re: SQL Server Export
This is what I resorted to doing. CF is extremely
This is what I resorted to doing. CF is extremely slow at this though...
time to learn some PERL.
What does it matter about speed unless your URGENTLY need to import the
files - if it can be done, run it over night and CFFlush between every file
so that your browser won't spit...
I'd export
You can get a script to export diagrams from
http://www.swynk.com/sqlhome/7library.asp
Thanks
--
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
You can get a script to export diagrams from
http://www.swynk.com/sqlhome/7library.asp
Justin
-Original Message-
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 2:11 PM
To: CF-Talk
Subject: SQL Server export/import preserving diagrams
If you
9 matches
Mail list logo