Red Gate forums :: View topic - Change Collation on all objects in database
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager Previous Versions
SQL Packager Previous Versions forum

Change Collation on all objects in database

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
jallman



Joined: 08 Jun 2006
Posts: 4

PostPosted: Mon Feb 11, 2008 8:44 pm    Post subject: Change Collation on all objects in database Reply with quote

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
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Fri Feb 15, 2008 12:47 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group