Change Collation on all objects in database

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Change Collation on all objects in database

Postby jallman » Mon Feb 11, 2008 8:44 pm

Is there a way I can use SQL Packager to update the collation order on all objects in a database?

Thanks,
John Allman
John Allman
jallman
 
Posts: 4
Joined: Thu Jun 08, 2006 4:35 am

Postby Chris Auckland » Fri Feb 15, 2008 12:47 am

Thanks for your post.

Yes you can use SQL Packager to change the collation when installing a new database.

You can do this one of two way:

1. During the setup of the project:

When setting up a new project, on the last step of the wizard select the 'Extra Package Info' button. You can set the new collation in the 'Database Properties' tab.

2. When running the package:

When you run the Package, select the 'Advanced' option and change the collation.

I hope this does what you need.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests