[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: svn for SQL Server's Stored procedures?

From: eg <egoots_at_gmail.com>
Date: 2006-04-25 18:07:44 CEST

Andy Levy wrote:

> The code
> changes are easy. For the database, we don't make table changes via
> SQL (we use the GUI), and we don't have stored procedures. I go into
> Enterprise Manager and script each object in the database, and check
> the resulting files into SVN. Then the diff from one month to the
> next tells me what, if anything, has changed. I used the procedure
> described here ->
> http://www.databasejournal.com/features/mssql/article.php/3389411 to
> create the SQL scripts; just make sure you select "one file per
> object" to make diffs easier.
>

If you want to diff the scripts with subversion, just make sure that
when you generate scripts you always select the Ansi and not Unicode
file format from the dialog. Subversion will treat unicode files as
binary files I believe.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Tue Apr 25 18:09:49 2006

This is an archived mail posted to the Subversion Users mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.