Comments
3 comments
-
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 -
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
-
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?
Add comment
Please sign in to leave a comment.
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