Some newbie questions...

Forum for users of SQL Compare schema synchronization utility

Some newbie questions...

Postby wibblemonkey » Thu Sep 29, 2011 2:00 pm

Hi,

I've downloaded the trial edition of SQL Compare to assess whether it will meet our requirements, but I've hit a problem right at the start!

I have an old database that was created with all objects in the default [dbo] schema, and a new structure that has moved them into new individual schemas, e.g.

    OldDB
      dbo
        Table1
        Table2
    NewDB
      Schema1
        Table1
      Schema2
        Table2
      dbo
        Synonym1 (dbo.Table1 -> Schema1.Table1)
        Synonym2 (dbo.Table2 -> Schema2.Table2)


First of all, if I have an existing OldDB that I want to update to the NewDB structure, what is the source and what is the target? This nomenclature is ambiguous - my existing OldDB is the target of the update operation that I want to perform, but the goal is to end up with a database updated to look like NewDB, so NewDB is also technically "the target".

Either way, it doesn't appear to be possible to specify multiple mappings to a single schema. Given the above scenario, I would want to end up with the following:

OldDB.dbo.Table1 -> NewDB.Schema1.Table1
OldDB.dbo.Table2 -> NewDB.Schema2.Table2

so in either direction I would need a 1-to-many mapping for schemas.

I accepted the defaults and ran the comparison anyway, assuming that I would be able to manually map objects when the comparison was complete, but the online help appears to suggest that all I can do is include/exclude the matches that the compare has found, rather than being able to specify my own.

Can someone please confirm for me whether this is indeed the case, or have I misunderstood something fundamental from the get-go?

Cheers.
wibblemonkey
 
Posts: 3
Joined: Thu Sep 29, 2011 1:00 pm

Postby David Atkinson » Thu Sep 29, 2011 3:06 pm

We have a table mapping feature in the next early access release due out in the next couple of weeks. We'd be curious to know if it satisfies your use case. Shall I put you on our EA list so you are notified of its release?

David Atkinson
Product Manager
Red Gate Software
David Atkinson
 
Posts: 1136
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Re:

Postby wibblemonkey » Thu Sep 29, 2011 3:18 pm

David Atkinson wrote:We have a table mapping feature in the next early access release due out in the next couple of weeks. We'd be curious to know if it satisfies your use case. Shall I put you on our EA list so you are notified of its release?


David, that would be fantastic. Note though that as I said, I'm currently evaluating on the 14-day trial basis, and said 14-day period may have expired by then.

Jim
wibblemonkey
 
Posts: 3
Joined: Thu Sep 29, 2011 1:00 pm

Postby David Atkinson » Thu Sep 29, 2011 4:21 pm

If you get in touch with us we'll be happy to extend the trial. I've put you on the list.

Kind regards,

David
David Atkinson
 
Posts: 1136
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests