• If you can create and alter tables then you're halfway there. You'll need to do both to get this done. The most important thing you need to do is make sure you have recent backup before you start. If anything goes wrong you'll need to be able to restore your data. This is an area I can't help you in because it's not something I've done so it will definitely be worth reading up on it.


    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537