Using Visual SourceSafe With Sql Server
Jul 23, 2005
I've ready many of the posts on this and other newsgroups in which
people describe working practices for source control of database
scripts. We are looking to implement something similar in my current
workplace.
We have agreed that developers should not modify objects such as views
or stored procedures directly, they should check the script out of VSS
first, modify it, run it, and then check it back in.
The problem we are having is finding a quick, easy way to run all the
scripts in VSS in the right order, to create a new database. If we
don't run them in the right order the sysdepends table will be
incorrect.
If anyone has any suggestions please let me know.
Regards,
Ross Neilson
Software Developer
Interactive Products Ltd.
View 5 Replies
ADVERTISEMENT
Jan 12, 2007
The develpment team where I work is using Visual Studio 2005, SQL Server 2005 and Team Fundation Server. We want to somehow track changes of the stored procedures. We could create a Solution/Project in the SQL Server Management Studio, add all stored procedures to it and add that Solution/Project to the SourceSafe but nothing will stop developers from directly altering stored procedures.
Any ideas on how to prevent developers from making changes to the stored procedures directly?
Thanks.
View 1 Replies
View Related
Feb 20, 2007
Hi,
How is it possible to link the stored procedures in sql server to Source Safe?
The idea is that if anyone goes to sql server and wants to change a stored procedure, he has to check out/in, etc... Just like the way it is done is Visual studio with Source safe.
Thanks
View 5 Replies
View Related
Jul 23, 2005
HiIs it possible to use Visual Source Safe with SQL Server inorder to keep track of all modifications done to stored procedures?What are the pros and cons ?Thanks, Eugene
View 4 Replies
View Related
Mar 14, 2007
Imagine opening SQL Server Management Studio (SSMS), drilling into adatabase, and seeing all objects with little lock symbols in front ofthem. That would be true SS integration.Maybe next version?I know about creating a project in SSMS and managing connections,queries, and misc there, but come on, that seems a far cry from what Ilong for.I searched for 3rd party tools and found SQLSourceSafe and Apex SQLTools. Does anyone have experience with those?-Tom.
View 2 Replies
View Related
Aug 15, 2006
Recently, my company's deveolpment machine crashed. We had to format the harddrive which meant we lost some of our databases.
We managed to restore the databases, but we do not know in what state, i.e. which stored procedures were written between the restore point and the point the machine crashed.
Tow questions related to this:
1. I was wondering if there is any product that is similar to soursesafe but appied to databases, so that this problem will not happen again. Does Enterprise manager do something like this?
2. I was also wondering if there was anyway to undo an sql command. e.g. my colleague recently ran a command to update a database, but forgot to write the where clause!! That data was recovered aswell, but it would be nice to have some sort of undo button.
Thanks in advance.
Jagdip
View 1 Replies
View Related
Mar 20, 2007
When adding a SSIS DTSX package solution to Sourcesafe the SSIS Package Configuration file (.DTSConfig) is not included. We are using sourcesafe version 6.0d and Visual Studio 2005 Team Edition for Developers.
View 4 Replies
View Related
Apr 24, 2006
Where can I find information about how to integrate a SQL 2005 database with either SourceSafe or Team Foundation Server Version Control?
I would like to have database changes for tables, views, stored procs, etc. under source control. Is this even possible?
View 3 Replies
View Related
Jan 5, 2007
Hi All... Well, another old c++ programmer has found the Lord - I've just written my first stored procedure. And yes, as I've always heard, it's quite cool...
The thing I've never really cared for though is that they sit way out there in the database, far away from all the "other" code. I'm presently involved in an asp.net project and we use SourceSafe. I've seen some mention of VSS with SQL Server on this site and am quite pleased to see it! But for the sake of an old c++ programmer, what are the basics about getting things like stored procedures (and even the database schema for that matter) into sourcesafe? That is what's the easiest way to do it? ; )
For what it's worth, we're using .Net 2.0, Visual Studio 2005, SQL 2005 and VSS 6.0. Thanks for the tips! -- Curt
View 8 Replies
View Related
Apr 25, 2007
I've figured out how to store new SSIS projects in SourceSafe, but is there a way to configure an agent job to execute a package from SourceSafe, or do I have to maintain a copy outside? (Which doesn't seem to make sense...)
TIA
View 13 Replies
View Related
Apr 21, 2007
Hi,
In SQL Express SP2, when I select Tools > Options, there is a place where I am supposed to be able to specify the source control plug-in. I have SourceSafe 2005 installed on this machine, so I see these choices in the drop-down:
None
Microsoft Visual SourceSafe
Microsoft Visual SourceSafe (Internet)
The problem is that whenever I select one of the SourceSafe options, it goes back to "None".
I'm not even sure how the source control intergration works, but I figured I have to select the plug-in before doing anything else.
How can I select the SourceSafe plug-in under SQL Express SP2?
Thanks,
Mark
View 7 Replies
View Related
Aug 10, 2007
I get errors when I check out an SSIS package from source control (both Source Safe and TFS) relating to the connection objects where I was not the original developer who checked it in. Is there a solution to this other than altering the connection loginpassword for every connection object in the package before deploying?
View 4 Replies
View Related
Jan 16, 2008
Hi,
I've added an XML package configuration file to my SSIS package and it appears to be working fine.
The XML file is located in the same folder as the solution file.
I've recently added the entire solution to Visual Sourcesafe 2005, and I achieved this by doing the following:
1. Right-clicked on the Project name in the solution explorer and selected "Add to source Control".
2. When prompted, provided my Sourcesafe login credentials and clicked "OK"
3. Accepted the default VSS project name and clicked "OK"
4. Clicked "Yes" to allow VSS to create a new project
Problem: The XML configuration file hasn't be added to sourcesafe along with rest of the solution.
I'm able to add the file manually myself, but this doesn't seem right to me. Am I missing something? Should the config file show as part of the Solution in Visual Studio 2005?
Any answers/help would be appreciated greatly.
Thanks
Jon Derbyshire
View 4 Replies
View Related
Apr 11, 2006
I've downloaded and installed both of these (VWD installs both) and have been trying to run through the walkthrough of setting up a web application which supports membership. However, no matter what I do I invariably get errors like the following:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
I'm concerned why VWD and VSQL express versions don't run correctly out of the box (so to speak). I'm not an expert on configuring these services -- but that's the point of offering these tools to hobbyists: So we can learn about how to make some of these great applications using MS tools.
My configuration::
Windows XP SP2 -- clean machine as of about a month ago, never had any dev tools, web servers, or the like on it.
IIS is installed and the service says its running
VSQL and VWD express versions installed (no errors on installation)
SQL server service indicates it is running
.Net 2.0 framework installed (no errors on installation)
Note: I've tried installing on two separate machines. Obviously I'm missing something fundamental.
Would someone please help me go through the million things I [apparently] need to do to configure all these tools so I can get on to actually coding up my first web application? If this is documented somewhere, all I can say is I tried to find it but it certainly wasn't obvious.
View 3 Replies
View Related
Aug 24, 2006
We have a project already developed iusing VS 2003 Enterprise architect edition using sql server 2000(have lots of table and stored procs etc.)
Now planning to switch to Sql server 2005 are there any issues associated with the switch.
I mean front end programming wise asp.net and vb.net front end codes do they work straight away or need to make any changes to all the front end codes, we are using datasets, data readers calling stored procs and also using lot of hash tables and XML object to make bulk loads to sql server via sqlxml3.0 sp3.
Please help thank you very much for the information.
View 1 Replies
View Related
Aug 26, 2007
I have a question about a problem that I cannot seem to tackle. I have installed the following programs on Windows Vista:
- SQL Server 2005
- Visual Studio 2008
- SQL Server Compact Edition 3.5
- SQL Server Compact Edition 3.5 Server Tools
I want to do the following:
1. I want to create a SQL Server Compact Edition 3.5 database in the SQL Server Management Studio
2. I want my SQL Express server in SQL Server 2005 to be a distributor and publisher
About 1. In SQL Server Management Studio I cannot choose SQL Server Compact Edition 3.5 .
ABout 2. I tried to setup my server to be a distrubutor by running a stored procedure with the following name: sp_adddistributor. I get the following error: This edition of SQL Server cannot act as a Publisher or Distributor for replication.
Does anyone have a solution to both problems.
View 1 Replies
View Related
Dec 27, 2004
Good day all,
I am no longer able to manage SQL Server at the server explorer in Visual studio. i.e. create, modify and delete for Diagrams, Tables, Views, Stored Procs & Functions. Further more, it missing Diagram and function folder. I can only view or read data.
But I can access local MSDE as usual.
Whats I have done wrong? Please Help. Thanks.
View 2 Replies
View Related
Nov 14, 2007
Hey,
Im trying to make a website that I can enter information on the website and have it transfered to the database the problem is the website and database are on two different computers , how do I copy the data base onto the other computer and have it will be ready to take information from the website and store it in the database?
View 3 Replies
View Related
Feb 15, 2001
HELP!!! I've looked at a few, but none of them support insert and update. I hate to say it, but the Access inteface is better, but uses a different SQL than SQL Server. :(
Help,
mike
View 3 Replies
View Related
Jul 15, 2004
Hi,
Today was my first day to use DTS. I tried to transfer a Visual FoxPro Database to my SQL Server. I noticed that I am getting errors on the data that contains date fields. So, for testing purposes I transformed the Visual FoxPro fields that contained datefields into char fields. And this works, but obviously I cannot hunt around in a huge database looking for datefields in tables and change them manually. Plus, by changing to char fields I noticed that those fields that are empty are transformed as 1899-12-30. :p
Does anyone have any ideas?
Thanks,
Laura
View 3 Replies
View Related
Jan 3, 2004
Hi experts I am new to SQL Server and have got to do a project using VB & SQL Server. right now i got to prepare case study document wherein i got to mention the pros & cons of using VB+sql server... kindly help me. Thanks in advance.
View 1 Replies
View Related
Mar 13, 2007
Hi there, I am a newcomer to SQLExpress. I have installed Visual Studio 2005 and have been playing with it. Now I need to make a DB project with SQL server but I can not find a way to run the scripts (provided) to create the database I need.
Does anybody can help with this elementary question?
best
jose
View 1 Replies
View Related
Feb 12, 2008
In MFC programming, I have created a dialog box and displayed an edit box.
Please tell me how to retrieve values from SQL server and display in the edit box?
The edit box with the retrived details should appear as read only.
View 1 Replies
View Related
Oct 25, 2007
Can anyone point me to a tutorial where it is explained how connect Visual Studio to SQL Server 2005 and also 2000 and also MySQL?
View 3 Replies
View Related
Sep 10, 2007
I wrote an application on my home machine using Visual Studio and SQL Server. The application runs fine. This application needed to be installed on a server for a company.
I copied the executable and the library files to the company server. The Machine is a Windows 2003 Small Business Server with SQL Server engine installed already. So I installed SQL Server Express to be able to use the Engine and build my database on the server.
When I ran the executable it would not connect to the server even though I changed the settings in the connection string to the sql server on the SBS Server.
I installed Visual C# Express on the machine to debug the application and I can not get the data source to connect to the SQL Server.
I get the following error
SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
any help will be extremely appreciated. thank you
View 3 Replies
View Related
Oct 13, 2006
Yes I am a newby (or is that newbie) and this is my first post.My Visual Web Developer site work really well on my PC, I read the books took it slowly, created logins and sql tables and then found a good hosting company with Server 2005 ... I though I was one step away from the road to success ... then I hit the big brick wall. Spent hours on Google trying to find some answers without joy ... all I found were lots of users with the same or similar problems ... and some answers that caused more problems !1) Please can someone give my a 'step by step' idiots guide on how to convert my ASPNETDB.MDF content to run on Server 2005. I have Server Management Studio so I am happy about loading the translated files but I don't understand how to break them down into tables and logs.2) Once the files are across can I run a connection string from VWD directly to the tables on the server instead of SQL local ? I assume that is set in web.config !!.... normally I am happy to learn by trial and error. But I can't get around or over this brick wall.Welcome assistance, advice or a ladder ... with simple instructions ?
View 2 Replies
View Related
Jan 18, 2008
hi., i need help.,i Created a database using the SQL Server 2005 Express SQL Server Management Studio Express (SQL Server MSE)but i don't know how can i get the database that i made to put it in the Folder "App_Data" in my Visual Web Developer (VWD). is there any process or something to connect my database that i make using the SQL Server MSE to the VWD?Please help me, THanks
View 3 Replies
View Related
Aug 3, 2001
is there any way to use Visual Basic and MSSQL without using ODBC?
please let me know.
View 1 Replies
View Related
Jun 9, 2006
i have visual web developer make the asp.net.mdf that it auto made, for the users and roles, i added 2 more coloms to the database in the membership table called address and phone
when i make a sqldatasource and give it a select and insert command, i also give it a couple dummy values to test it this is my code,
Protected Sub CreateUserWizard1_CreatedUser(ByVal sender As Object, ByVal e As System.EventArgs)
SqlDataSource1.InsertCommand = "INSERT INTO aspnet_Membership(Address, Phone) VALUES ('9', '2')"
End Sub
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:saveaddnphone %>" SelectCommand="SELECT Address, Phone FROM aspnet_Membership"></asp:SqlDataSource>
Instance failure.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Instance failure.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[InvalidOperationException: Instance failure.]
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
System.Web.Security.SqlMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status) +3612
System.Web.UI.WebControls.CreateUserWizard.AttemptCreateUser() +305
System.Web.UI.WebControls.CreateUserWizard.OnNextButtonClick(WizardNavigationEventArgs e) +105
System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) +453
System.Web.UI.WebControls.CreateUserWizard.OnBubbleEvent(Object source, EventArgs e) +149
System.Web.UI.WebControls.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) +17
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
View 2 Replies
View Related
Oct 17, 2007
i have built a web project in visual studio, and i have an instance of sql server express running. when i try to access a database(which is located in the file system) through the web project, i get the following message:
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Unable to open the physical file "C:dbSAMdbSAM.mdf". Operating system error 5: "5(Access is denied.)".
An attempt to attach an auto-named database for file C:dbSAMdbSAM.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
i am running visual studio 2005 professional, on windows XP pro with IIs installed. i also have a report server on the same sql server instance.
any help would be greatly appreciated
View 1 Replies
View Related
Feb 5, 2007
Hi,
I would like to know if it is possible to change the appearance of SQL Server Reporting Services that we see when we are navigating in the reports by the browser. Like change the name "SQL Server Reporting Services" to the name of my company, change the default icon and the size of it, etc...
Thanks for the attention,
Gus
View 1 Replies
View Related
Jun 19, 2007
I am trying to add a FoxPro linked server to MS SQL 2005, and I can't seam to create a linked server that works. What am I doing wrong in linking the server?
I have an ODBC connection that worked but not OLEDB; how can I do this with OLEDB (either VFPOLEDB or Jet, if it will work) and not ODBC.
This is what I thought was right
Code Snippet
sp_addlinkedserver 'test',
'FoxPro',
'VFPOLEDB',
'C:DataSomeDatabase.dbc',
NULL,
NULL,
NULL
But it gives the error:
Cannot create an instance of OLE DB provider "VFPOLEDB" for linked server "test".
Also I know in MS SQL 2000 once you linked a server you could view it in EM, but when I linked the VFP via ODBC I could query agianst it, but I could not open it in Mangament Studio.
Thank you in advance.
View 11 Replies
View Related
