You could have DTS packages on one server that are not on your dev server
and by replacing the .mdf and .ldf it would erase any hooks to that package
that it didn't know about. What you are doing is basically taking and
entire SQL repository from your dev machine and placing it on your prod
machine. In theory they should be exactly the same, but there is always the
chance that someone made a change in production and didn't update the dev.
Also if you use security on your DTS packages it will most likely fail
because the ids in SQL are system generated SIDs which would be different on
another machine.
-----Original Message-----
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 9:11 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
I'd agree, but like I said, I've had some success with it, so file it
away as a "last resort". Just for my own curiosity, what would cause
corruption?
---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]
-----Original Message-----
From: Chris Sinkwitz [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 10:47 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
I would not recommend this way at all. This gives you a good change of
corrupting your database.
-----Original Message-----
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 8:38 AM
To: CF-Talk
Subject: RE: Importing saved DTS in SQL 7
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
