automated design change

MKB

hi i have database that have 250 tables and i want to do specific change design in some of tables like renaming column  ,changing datatype ,add identity ,changing primary key and add unique key .
I don't want to do in manually in SSMS and run change script i want to do it with program in C# that select database and do the change automatically is it possible to use SMO or is there any better solution i really appreciated for help
thanks in advance

Sergio R

Hi,

You could use a SQL Change Automation project.

For more detailed information please see the documentation page: https://documentation.red-gate.com/sca3/developing-databases-using-sql-change-automation

way0utwest

Smo will allow you to do this. I assume you're doing some looping and following a pattern in C#. There are classes to connect to tables and alter them as needed. You can start with the Table.Alter method: https://docs.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.management.smo.table.alter?view=sqlserver-2016

TomN

How does redgate automated handle extremely large database changes? With DACPACs there is an issue when the table is too large and complex and can lead to a fairly critical failure. How does RedGate mitigate this issue?