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??
Hi @PBuxton
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??