Copy Objects Dependencies

#1

I am trying to copy a "snapshot" of a remote sql server 2000 database to a
local sql server 2000 database. I just want to run a simple Copy Objects
dts, but it is choking on a user defined function.

Another object needs the udf but the udf hasn't been created. Is there any
straightforward way to fix dependency issues? I don't want to have to pick
specific objects to copy because it won't update if new objects are added.

#2

There are some third party products that do a much better job of this. The
scripter from
http://www.innovartis.co.uk/home.aspx
is only around $45 and can save you a lot of headaches.

--
Andrew J. Kelly SQL MVP

"Jed" <jedatu (AT) newsgroups (DOT) nospam> wrote

Quote:

I am trying to copy a "snapshot" of a remote sql server 2000 database to a
local sql server 2000 database. I just want to run a simple Copy Objects
dts, but it is choking on a user defined function.

Another object needs the udf but the udf hasn't been created. Is there
any
straightforward way to fix dependency issues? I don't want to have to
pick
specific objects to copy because it won't update if new objects are added.

#3

Hello,

Based on my scope, It seems that recursive dependencies are not handled
correctly by the Copy Objects Task if there are potential circle
dependences. You may want to use backup/restore for this situation which is
more efficient.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Quote:

Thread-Topic: Copy Objects Dependencies
thread-index: AcYFlwXIDy7p+4UMSCCKJESNef7+FQ==
X-WBNR-Posting-Host: 70.226.80.238
From: =?Utf-8?B?SmVk?= <jedatu (AT) newsgroups (DOT) nospam
Subject: Copy Objects Dependencies
Date: Tue, 20 Dec 2005 10:56:02 -0800
Lines: 9
Message-ID: <195D6A84-D755-406A-BCFA-7184AADA67CC (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.sqlserver.dts
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGXA03.phx.gbl
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.dts:62668
X-Tomcat-NG: microsoft.public.sqlserver.dts

I am trying to copy a "snapshot" of a remote sql server 2000 database to a
local sql server 2000 database. I just want to run a simple Copy Objects
dts, but it is choking on a user defined function.

Another object needs the udf but the udf hasn't been created. Is there
any
straightforward way to fix dependency issues? I don't want to have to
pick
specific objects to copy because it won't update if new objects are added.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Copy Objects Dependencies

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Copy Objects Dependencies - 12-20-2005 , 12:56 PM

Re: Copy Objects Dependencies - 12-20-2005 , 02:06 PM

RE: Copy Objects Dependencies - 12-20-2005 , 08:24 PM