I have a small database that needs upgrading as opposed to making changes to the production database i oftern take a backup and work on it offline. What is the best way of getting my changes (tables / views and procs) back into the live database?
at present im just making a note of my changes then replicating them manually back into the live database but this is sometimes a lengthy process.
just wondering what is the best practice for this?
Generally, I'd suggest that you get all the databases into source control and then come up with a mechanism for building your database out of source control (as previouisly mentioned Red Gate or Apex have tools, or there's Visual Studio or even writing your own) automatically. Then, you only make changes to the source code, deploy it to dev or to sandbox machines, qa, etc., label versions, and do targeted builds to prod. It's a pretty complicated process to set up, but really easy to maintain and has HUGE awards for time & effort in the future.