Red Gate forums :: View topic - Some newbie questions...
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Some newbie questions...

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
wibblemonkey



Joined: 29 Sep 2011
Posts: 3

PostPosted: Thu Sep 29, 2011 2:00 pm    Post subject: Some newbie questions... Reply with quote

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.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1123
Location: Twitter: @dtabase

PostPosted: Thu Sep 29, 2011 3:06 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
wibblemonkey



Joined: 29 Sep 2011
Posts: 3

PostPosted: Thu Sep 29, 2011 3:18 pm    Post subject: Re: Reply with quote

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
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1123
Location: Twitter: @dtabase

PostPosted: Thu Sep 29, 2011 4:21 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group