I'm in need of some assistance.
My current project is SQL Server 2012 Express BE and Access 2010 FE which performs all processes via stored procedures.
I have recently made the move from our original Development server to now having separate Development and Production servers. Note that this is my first project, I'm still learning things and I've been pushing to get separate servers for months
now.
Anyway, since I now have seperate servers, I've spent the last few days researching ways of rolling out updates from the development server to the production server.
My current plan is to script any table changes as alterations before saving them into a script .sql file, while all views, stored procedures and functions have their own separate scripts that perform the updates. This is a method that was
recommended to me and I'm liking it so far.
This puts me in the position of needing to run all these scripts (o ...
Go to the complete details ...