Custom Table Map Cannot Deploy

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

Custom Table Map Cannot Deploy

Postby duhnbr » Tue Aug 06, 2013 6:10 pm

1. Set up test scenario:
Code: Select all
   create database ABC;
   use ABC
   create schema abc;
   create table int, j int);
   create database XYZ;
   use XYZ
   create schema xyz;
   create table int);
2. Open SQL Compare GUI
3. Compare database ABC with XYZ
4. -->Edit Project-->Table Mapping: Map to
5. -->Compare Now
6. -->Select MyTable for deployment
7. -->Deployment Wizard (ABC-->XYZ)
Code: Select all
ALTER TABLE [xyz].[MyTable] ADD[j] [int] NULL

Code: Select all
ALTER TABLE [abc].[MyTable] ADD[j] [int] NULL
Posts: 10
Joined: Fri Mar 10, 2006 3:42 pm
Location: Earth

Postby Manfred.Castro » Thu Aug 08, 2013 8:56 pm

I believe you need to map the schemas in owner mapping.
In my attempts to reproduce your issue, once I mapped the abc schema to the xyz schema.
The I received the expected result. ... ing+owners
Manfred Castro
Product Support
Red Gate Software
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests