Schema Compare Sync script does not include owner

1 view
Skip to first unread message

Scott McCormick

unread,
Sep 15, 2009, 1:18:27 PM9/15/09
to DB Solo
I am comparing two SQL Server databases and generating a sync script
for them. Version 2 has the tables grouped in different schemas, and
version 1 does not.

When the sync script gets generated to move V1 to V2 everything looks
good, except the schema name is not used. This causes many of the
statements to fail, and is basically a pain.

Is there any way to have the application append the schema name when
generating the sync script?

DB Solo

unread,
Sep 15, 2009, 1:22:08 PM9/15/09
to db-...@googlegroups.com
This is currently only supported for Oracle, but it shouldn't be too
hard to add support for SQL Server.

Marko

Scott McCormick

unread,
Sep 15, 2009, 5:10:28 PM9/15/09
to DB Solo
That would be great. Do you have a time frame for when that would
occur?

On Sep 15, 10:22 am, DB Solo <mhant...@gmail.com> wrote:
> This is currently only supported for Oracle, but it shouldn't be too
> hard to add support for SQL Server.
>
> Marko
>

DB Solo

unread,
Sep 15, 2009, 5:51:12 PM9/15/09
to db-...@googlegroups.com
I can give a preview version probably later on this week.

Marko

DB Solo Admin

unread,
Sep 18, 2009, 5:48:17 PM9/18/09
to DB Solo
This should be fixed for SQL Server now. There's a new option on the
sync script settings panel named 'Include schema name in statements'.
If you check this option, the sync script will contain the schema name
in all statements. Please download the new version from dbsolo.com/
preview and give it a try.

Marko

On Sep 15, 5:51 pm, DB Solo <mhant...@gmail.com> wrote:
> I can give a preview version probably later on this week.
>
> Marko
>
Reply all
Reply to author
Forward
0 new messages