What are the challenges you face when working across database platforms? Take the survey

automated design change

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


Sign In or Register to comment.