Red Gate forums :: View topic - Change all varchars to nvarchar
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

Change all varchars to nvarchar

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Paul75uk



Joined: 09 Dec 2011
Posts: 1

PostPosted: Fri Dec 09, 2011 10:22 am    Post subject: Change all varchars to nvarchar Reply with quote

Hi

We want to make a bulk change to all tables - to change all instances of varchar to nvarchar.

Back in the day before SQL Source Control we would have done a find and replace throughout our SQL scripts to do this. We are working in a dev environment where we are yet to go live with the database, so upgrading users isn't an issue.

My question is, is it ok to go to the Tables directory (that is maintained by RedGate SQL Source Control) and do a find a replace here and then commit the changes? Or do I have to make this sort of change in Sql Server Managenment Studio? Or are there any other ideas how to make a change like this.

Thanks,

Paul
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Fri Dec 09, 2011 11:11 am    Post subject: Reply with quote

I wouldn't recommend changing SQL Source Control's own working folder as this isn't a supported scenario.

However, what you can do is to create a new working folder and check out your scripts folder to this, make any changes to the files, and check them in. Provided you're using the 'dedicated' model, you'll be able to return to SQL Source Control and run 'get latest' on these to update your development environments.

David Atkinson
Product Manager
Red Gate Software
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