I have a database on a hosetd sql 2008 server.
I have made some changes to the schema in development but don't want to upload this as I want to keep the data that is on the server.
Is there a script I can run that will backup the data in my tables, preferably also have a way to save the shema too.
Then I want to be able to upload the schema changes from dev and restore all the data from my backup.
I am looking for a free way to do this so I can't purchase any tools.