What are the challenges you face when working across database platforms? Take the survey
Options

Synchronization script error

gvar369gvar369 Posts: 20
edited July 11, 2011 11:06AM in SQL Compare Previous Versions
Hi,

I have a problem with one of the SP's i'm trying to synchronize with another database. I created the SP within a particular schema, but when i click on synchronize, it isn't showing the schema name in the synchronization script. It's showing CREATE PROCEDURE <Procedure_Name> instead of CREATE PROCEDURE <SchemaName>.<Procedure_Name>.
Following is the screenshot of the above mentioned error.
redgatess.png

This error is only specific to this SP only, other SP's went through fine.

Let me know if you need any additional information in resolving this issue.

Thanks,
Vijay

Comments

  • Options
    James BJames B Posts: 1,124 Silver 4
    Thanks for your post - I've just tried to replicate this here, but no joy so far.
    Part of the issue may be that the object in question already exists in the target, but under dbo instead of SOW - on the Owner Mapping tab of "Edit Project", have you mapped SOW to anything on the other side?
    What versions of SQL Server are the two databases running on?
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.