Create a Duplicate Database - Different Collation

Answer 1

In the past to change to collation of a database I have used Red Gate SQL Compare. They let you download a trial version of the software which I think is fully functional.

Follow these steps below and you should have your new database up and running in no time.

1. Load up SQL Compare
2. Input the old database Server, username, password and database name on the left
3. Input the new database Server, username, password and database name on the right
4. Click "Compare now"
5. In the comparison window check everything you want moved over to your new database is checked
6. Click "Synchronization Wizard..." this will walk you through 3 or 4 steps making sure the move over to the new database uses the correct method and any depencancies you may have missed.
7. On the 4th screen you will see a Synchronize button. If you're happy with all your selections click it and this will move the database Schema over to the new Database.

Now you have the data schema over in the new database you need to repeat the process in SQL Data Compare You should find this quite straight forward as the process and screens are almost the same as in the steps above.

Hope this helps.