Copy a Cronus database to another Cronus database with different collation

dark_side61

Hi guys.
I'm trying to copy Cronus Iternational Ltd_ NAV database to one that has the same collation as my SQLServer.
What I did:
I scripted tha database, tables and views, and I created an empty one.
Now, the question: how do I polulate the new database with the data of the old one?
Any guess ?

I'm a newbie in this kind of thing, by the way...

Any help will be appreciated.

dark_side61

zohaibu95@hotmail.com

You can do by doing this:

1. Backup the database. For this go to NAV development environment. Click on Tools -> Backup -> Entire Database.

2. Once the backup has been done, create a new database by going in the File->Database -> New.

3. Select your sql server instance and click next.

4. Click on Collation tab and select your language.

5. Uncheck validate collation

6. Restore the backup you have created.

Thats it