In situations like that, I usually burn SQL Server's data files (.mdf
and .ldf) to a cd. Copy the files into SQL Server's data directory.
This *should* work. Not the cleanest method, but I've had good
experience with it.
---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]
-----Original Message-----
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 9:27 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
Its a very unique situation. We have a training lab here that is
completely cut off from the outside world. One of our clients is coming
in to train on our applications. Al of their data is on our live DB,
but I need to be able to save something to disk to carry over to the
training server and import it. I have already saved a .dts file of the
db and now I can't figure out how to import it.
Tim Heald
ACP/CCFD :)
Application Development
http://www.schoollink.net/
-----Original Message-----
From: Mark Stewart [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 10:08 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
Tim,
Need a little more detail here. Where do you want to import from/to? Is
it safe to say that you've created a DTS package on, let's say, a dev db
server and you now want to export it to your production db server?
Mark
-----Original Message-----
From: Timothy Heald [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 10:03 AM
To: CF-Talk
Subject: OT: Importing saved DTS in SQL 7
Hey,
How do I go about importing a saved DTS once I have it?
Tim Heald
ACP/CCFD :)
Application Development
http://www.schoollink.net/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
