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

Custom Table Map Cannot Deploy

MCTSQLMCTSQL Posts: 14 Bronze 3
edited August 8, 2013 3:56PM in SQL Compare Previous Versions
1. Set up test scenario:
create database ABC;
   go
   use ABC
   go
   create schema abc;
   go
   create table ABC.abc.MyTable(i int, j int);
   go
   create database XYZ;
   go
   use XYZ
   go
   create schema xyz;
   go
   create table XYZ.xyz.MyTable(i int);
   go
2. Open SQL Compare 10.4.8.87 GUI
3. Compare database ABC with XYZ
4. -->Edit Project-->Table Mapping: Map ABC.abc.MyTable to XYZ.xyz.MyTable
5. -->Compare Now
6. -->Select MyTable for deployment
7. -->Deployment Wizard (ABC-->XYZ)
8. EXPECTED (CORRECT) RESULT:
ALTER TABLE [xyz].[MyTable] ADD[j] [int] NULL
ACTUAL (INCORRECT) RESULT:
ALTER TABLE [abc].[MyTable] ADD[j] [int] NULL
MCTSQL

Comments

Sign In or Register to comment.