Interdependent functions (udf)

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Interdependent functions (udf)

Postby out_law77 » Fri Jul 11, 2014 9:56 am

Hello,

We have two udf-functions which are interdependent and can call each other recursivly.

Changing the parameters and update a database with SQL compare leads in an error.
The reason is clear - but how can I avoid the error? Is there a way to solve this without Scripting?

Thank you for any help or hints!
regards,
Robert
out_law77
 
Posts: 1
Joined: Fri Jul 11, 2014 9:37 am

Postby eddie davis » Mon Jul 14, 2014 4:04 pm

Thank you for your forum post.

You obviously have a circular dependency. One way to resolve this is to break the circular dependency and manually script the change.

Or create temp objects with the new structure. Export the data out of the existing tables and insert into the temp tables. Drop the existing objects and rename the temp objects to take over the role of the objects that were dropped.

Either way, you will need to perform some scripting.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest