Options

New functionality request

PBuxtonPBuxton Posts: 3 New member
I'm in a possibly unique use case here.

I have multiple databases that have  identical tables in terms of the core columns, but have a difference in Indexes created, and in default values.  By way of a very simple example.......

DB1 - CustomerUsers

Id int identity(1,1)
UserId int
CreatedDate datetime default '2023-02-01'

Index IX_UserID on UserID column


DB2 -CustomerUsers

Id int identity(1,1)
UserId int
CreatedDate datetime default '2023-03-08'


SQL Compare rightly detects the different in the default constraint and the index difference.

What I need to do is   *migrate over ONLY the index*

The product will update the default constraint as well, which I don't want.

What I can't do is migrate only the index.

I'd love for the product to do this as I'm dealing with lots of DBs where the variations are as above.

I can't believe I'm the first to ask for this??

Tagged:

Answers

Sign In or Register to comment.