New functionality request
PBuxton
Posts: 3 New member
in SQL Compare
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??
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
I would advise posting the feature request here to be reviewed: https://redgate.uservoice.com/forums/141379-sql-compare?query=index
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?