Versioning/Change Management For SQL Server 2000 Databases
Hi,
Is there any version control system that will take care of versioning/change management of a SQL Server Database.
Regards,
Swami
View Complete Forum Thread with Replies
Related Forum Messages:
SQL Server 2000 Databases To SQL Server 2005? Enterprise Manager And Management Stuio At The Same Server?
When I proposed start to use SQL Server 2005 for new VS 2005 web sites, one of my co-workers responded that we will update the old SQL Server 2000 databases to SQL Server 2005 when we are ready to use 2005 SQL Server. Questions: 1. Any expected problems to upgrade old 2000 databases to new 2005 SQL Server? 2. I have installed both 2005/Management Studio Express and 2000/Enterprise Manager in my PC. Any expected problems when running both 2000 and 2005 SQL Server at the same database server? 3. What is the best configuration for running SQL Server 2005 when we have old 2000 databases? Upgade or not upgrade? TIA, Jeffrey
View Replies !
Row Versioning In SQL 2000?
I replicate (transactional replication) my data entry database to aread-only database. Both are SQL 2000+SP4. The web server reads theread-only database. At times, there will be lots of changes in the dataentry database, thus lots of replications to the read-only database. Iam concerned that the replication may lock the data in the read-onlydatabase, causing slow response to the web server.I would like to use row versioning so that the read-only database cansupply old data when the same row is being written by replication. Iread that row versioning is a feature in SQL 2005. Is there anyversioning capability in SQL 2000?Thanks
View Replies !
Change Index Of All Tables, In At The Databases On A Server.
Hi, I am working on a script to do following: get a list of indexes on all tables in all dbs on a SQL server. If the index property to allow page locks is off, then turn it on, re-index and turn it off again. My problem is: i want to use ' Use <db>' statement in the middle of my script but it is not working.I tried using dynamic SQL with set @cmd='use '+ @dbname exec (@cmd) But this is not working. Can we use 'use' statement in the middle of a script? If not what is the alternative? My script looks as follows: DECLARE @Database VARCHAR(255) DECLARE @Table VARCHAR(255) declare @Index varchar(255) DECLARE @cmd NVARCHAR(500) DECLARE @fillfactor INT SET @fillfactor = 90 DECLARE DatabaseCursor CURSOR FOR SELECT name FROM master.dbo.sysdatabases WHERE name NOT IN ('master','model','msdb','tempdb','distrbution') ORDER BY 1 OPEN DatabaseCursor FETCH NEXT FROM DatabaseCursor INTO @Database WHILE @@FETCH_STATUS = 0 BEGIN SET @cmd = 'DECLARE TableCursor CURSOR FOR SELECT table_catalog + ''.'' + table_schema + ''.'' + table_name as tableName FROM ' + @Database + '.INFORMATION_SCHEMA.TABLES WHERE table_type = ''BASE TABLE''' -- create table cursor EXEC (@cmd) OPEN TableCursor FETCH NEXT FROM TableCursor INTO @Table WHILE @@FETCH_STATUS = 0 BEGIN set @cmd='use '+@Database print (@cmd) exec (@cmd) declare IndexCursor CURSOR for select name from sys.indexes where object_id=object_id(@Table) open IndexCursor fetch next from IndexCursor into @Index print (@table) --select name from sys.indexes where object_id=object_id(@Table) print (@index) WHILE @@FETCH_STATUS = 0 begin if (INDEXPROPERTY(OBJECT_ID(@Table),@Index,'IsPageLockDisallowed')=1) begin print (@Index + ' page locking off') -- SET @cmd='ALTER INDEX '+@Index +' ON '+@Table+' SET (ALLOW_PAGE_LOCKS = ON) reorganize -- ALTER INDEX '+@Index +' ON '+@Table+' SET (ALLOW_PAGE_LOCKS = OFF)' end else begin print (@Index + ' page locking on') -- SET @cmd='ALTER INDEX '+@Index +' ON '+@Table+' reorganize' end --PRINT (@cmd) fetch next from IndexCursor into @Index end CLOSE IndexCursor DEALLOCATE IndexCursor FETCH NEXT FROM TableCursor INTO @Table END CLOSE TableCursor DEALLOCATE TableCursor FETCH NEXT FROM DatabaseCursor INTO @Database END CLOSE DatabaseCursor DEALLOCATE DatabaseCursor Can anyone help me please?
View Replies !
Managing SQL Express Databases With Standard Version Of SQL Server Management Studio
I have a windows 2003 server which has SQL 2005 Express with advanced services installed on it. Then a few weeks back the company purchased SQL server Standard Edition which comes with SQL Server Management Studio (which has more features than SQL Server Management Studio Express currently installed on the server where sql express is running)I have been trying to schedule a maintanance plan on the SQLExpress Instance database from the SQL Server Management Studio that came with the standard version of sql but i have not been able to have all SQL Server Management Studio functionality available when connected to the SQLExpress instance. So is there a way i can connect to the Express Instance from management studio(that comes with the standard edition of sql) and have all its functions available when working with a SQL express database. Or i must upgrade the express database?
View Replies !
Installing Microsoft SQL Server Management Studio Express Broke My Asp.net Databases
Morning, I installed the managerment stuid on my machine and now none of my database connections seem to work any more. I keep getting the attached error. Before I installed the studio the system worked fine, I could connect to the database and everything was fine. Does the studio change any permission stuff? I cannot seem to get it to work again at all now, I added in aspnet as a login inside the studio and it still won't let me connect to the database. I cannot find *any* logs anywhere that might be helpful in what it is doing or see any way to debug the connection to find out what the problem is. When I look at the permissions inside of the studio it shows me that the connections should all be fine. I checked and remote and local connections are setup, although it is only doing local connections anyway since this is a asp.net web server page. Any idea what the problem is here? This is very frustrating and annoying :( Since I didn't change anything and now nothing I will do gets it to work. I even tried to uninstall the management tool and it still doesn't work. Cannot open user default database. Login failed. Login failed for user 'GREENANDFLUFFYASPNET'. 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: Cannot open user default database. Login failed. Login failed for user 'GREENANDFLUFFYASPNET'.
View Replies !
Versioning - Deploy Just The Changes To The Server
At ScottGu's Blog about "Database Publishing Wizard", AlexD from codeplex said: "Regarding the multiple requests for versioning, backup/restore of remote database, and selection of individual objects - these are all things we are actively looking at for our next release in the first half of 2007." After so many searches, I still don't know if this tool performs Versioning, i.e, when deploying the database, just update de diferences between the local and server database. Did Visual Studio Express 2008 have somethingh like that? (I know that VS Team Edition 2005 had). If this tool can't make it (versioning), which tool/method did you recomend me? Thanks in advance. Alberto
View Replies !
Versioning Stored Procedures With SQL Server 7
Followed instructions in "Versioning Stored Procedures with Visual Studio 6.0 and SQL Server 7.0," but am not able to add a database to source control. When I right-click the data connection in the Data View window, "Add to Source Control" is not enabled. Also, when installing InterDev Server, got a message that it hadn't been tested with NT 4 (which we are using); continued setup anyway. Could this explain the problem?
View Replies !
SQL Server Management Studio &"Change Type&" For Querys Is Greyed Out
This is driving me a little nuts, I have been testing locally with SQL Server Express 2005 and this has not been a problem, however now that I have restored the databases to SQL Server 2005 (not express) When I go into SQL Server Management Studio open a table the option for changing a query type is greyed out has anyone seen this or have any ideas how I can get this working. Thanks, Terry
View Replies !
SQL Server Management Studio Express (SSMSE)=&&>Object Explorer=&&>Databases Has C:SSMSE-BookChapter12WINCH12NORTHWND.MDF?
Hi all, In my SQL Server Management Studio Express (SSMSE)=>Object Explorer=>Databases, the "NORTHWND" database was screwed up and is deleted completely. But under the same Object Explorer =>Databases, there is a database "C:SSMSE-BookChapter12WINCH12NORTHWND.MDF". I need to use this "NORTHWND" database in the SqlConnection. How can I specify the "Initial Catalog" (or "database") in the New SqlConnection code statement (in the ADO.NET 2.0-VB 2005 Express programming)? Should it be like the following: Dim sqlConnection As SqlConnection = New SqlConnction("Data Source=.SQLEXPRESS; Initial Catalog=C:SSMSE-BookChapter12WINCH12NORTHWND; Integrated Security=SSPI;") ? Or what is the right code statement for connecting to it? Please help and advise. Thanks in advance, Scott Chang
View Replies !
Remote Management Of Sql Server 2000
One of my clients is upgrading to Sql 2000. I currently administer her server using a SQL 7 interface but I will need to upgrade that interface to sql 8 now to be able to give her the same level of support. How do I go about installing the required clients on my desktop in such a way as to not interfere with my own installation of MSDE? I use Windows NT workstation 4. If I have a choice do I install developer's edition of SQL2000 or personal edition? We also have pcanywhere access but this is too slow and unsure for my money. Thank you, Bo Graham
View Replies !
Management Studio With SQL Server 2000
Hello, This is a bit of a beginner questions... I need to start managing an SQL server 2000 using SQL server management studio (2005). I've heard there may be an issue with backwards compatibility, which might cause error when creating new tables or stored procedures... could someone please list the pros and cons on this? Thank you all in advance
View Replies !
SQL Server 2000 - How Do I Change The Name?
I need to change the name of the SQL Server on my development machine. Myclient's server name is "Server1". My development server name is"MachineName1ServerTest".I am writing a Visual Basic application. Everything is working great on mydevelopment system, but I have to go in a change the connection strings.Each time I change one, it takes about a couple minutes for the prompt tocome back saying it timed out trying to find the server. I want to renamemy server to be the same as my client's server so I won't have this time outannoyance in my development environment.I did a sp_dropserver and sp_addserver, but that does not change the machinename of the server. Thanks in advance for any help.
View Replies !
Creating A SQL Server 2000 Compatible .BAK File From SQL Server Management Studio Express
Hi,My webhost (1and1) is running SQL Server 2000 and their web tool supports the import of .bak files. However, when I try to import my .bak files created in SQL Server Management Studio Express I get the following error:"The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database. RESTORE FILELIST is terminating abnormally."I have Googled this error and learnt that 2005 .bak files are not compatible with 2000 .bak files. I'm just wondering if there are any work arounds to this or alternative tools that I can create 2000 compatible .bak files from from 2000/2005 .mdf files.Thanks in advance.
View Replies !
SQL Server Management Studio Can't 'see' The 2005 Engine?? But Can See 2000 ?!?
Hello,I had SQL2000 server running fine on the windows 2003 box. I then installedSQL 2005 Express. They both worked together fine. I then uninstalled SQL2005 Express and installed SQL 2005 Server. But when I open SQL ServerManagement Studio, I can only connect to the SQL 2000 engine. In the Objectexplorer, it says v8.0.2039 (which I think is SQL 2000 Server, because I cansee the existing SQL 2000 databases).How can I get SQL Server Management Studio to 'see' the SQL 2005 databaseengine so I can create tables? I *think* its running because there is the'sqlservr.exe' process running, and during installation there is no issues.When I open SQL Server Management Studio, I choose 'Database Engine', thenmy local Servername with Windows Authentication. How do I connect to the SQL2005 instance?Thanks,Jack.
View Replies !
How To Stop / Start Sql Server 2000 Using Management Studio
Hi I have upgraded my local to sql server 2005, but still need to access the remote instance which is still at version 2008/8.0. Enterprise Manager has been removed (by the SQL server 2005 installation) Does anyone know how I can restart older version of SQL server instance (ie 2000/8.0) using SQL server Management Studio? I don't have admin access on the server which the sql remote instance is hosted. Can get around it by asking the sys admin guy to do it for now but would prefer to continue to be able to do it myself. SQL Server Configuration Manager can only manage SQL server 2005 versions - a nice little caveat! Is there a way to stop/start remote services using 'net stop/start'? - without having to write code.... I'll continue to search for a solution, but if someon can point me in the right direction, I'd be most greatful. hien
View Replies !
Change Management Systems
Does anyone work with or know of a good change management system for managing changes being made within SQL as well as coding changes in VB. Any recomendations is greatly appreciated. Thanks!
View Replies !
Change Management - SQL7
Has anyone had success with setting up a change management (CM)system to manage schema versions, and stored proc deployments to production in a SQL environment? We have an integrated data warehouse with crm, and reporting db's and I'm investigating tools to track bugs in stored proc code, dts.... any insight to vendors, links, articles is appreciated. thanks, aj
View Replies !
Change Management Tools
Hi I'm looking into various technologies that can make our lives easier. I have a number of processes to define, including: Auto rollback scripting Deployment to different environments (dev, test, production)Generation of deployment scripts from source control Tracking deployments (generation of reports detailing exactly what occurred in a deployment) Rather than try to custom the processes, I've decided to use a technology that already does the above and more. Can anyone recommend any tools? I've looked briefly at SQL Farm Combine which looks good. Anyone using this? Hearty head pats
View Replies !
SQL Server 2000 Migration To SQL Server 2005 Collation Change - Method?
Scenario Recently moved a SQL2000 database to SQL2005. Collation on SQL 2000 database server was SQL_Latin1_General_CP1_CI_AS Colaltion on SQL 2005 database server is Latin1_General_CI_AS After restoring the SQL 2000 database on SQL 2005 we observed that the database collation was SQL_Latin1_General_CP1_CI_AS. We have altered the database collation to Latin1_General_CI_AS. We understand this will work for all new objects created on the database but existing objects (prior to the collation change) will continue to have the 'SQL_Latin1_General_CP1_CI_AS' collation. What is the best method to change the collation of the older columns to 'Latin1_General_CI_AS' - 1) Run ALTER TABLE ALTER COLUMN <colname> <datatype> COLLATE Latin1_General_CI_AS <nullability> on each varchar/char column or 2) For each table BCP out data DROP TABLE RECREATE TABLE (taking the new collation Latin1_General_CI_AS) BCP in data 3) Other methods? Thanks in advance David.
View Replies !
SQL Server 2000 Replication And Joins Across Databases
Ok, I am in the middle of having several discussions at the company that I work for on SQL Server and the real functionality of it. What I am looking to find out is if it has real, realiable, and fast transactional, or immediate replication. This has been asked on both the Standard version and the Enterprise version. I know what the MS site states on the subject, but what I am looking for is experience in the matter. Has anyone dealt with this? What is thier experience in the matter? Does it work? What version (if it does). Also, another section of the discussion that I have had on SQL Server is about joining data across databases. Now, I don't mean across a schema, but across multiple databases, or catalogs. I don't believe that this can be done and I haven't found any information that leads in confirming or denying this. I will keep searching on this, but if anyone knows about this then let me know please. Thanks.
View Replies !
Attach/restore Databases In SQL Server 2000
Hi, I've got a question regarding attaching/restoring of DBs and wonder if anyone could help me out. Does SQL Server 2000 provide a functionality to attach/restore DB automatically? ie, some kind of polling service to attach/restore DB that were detached previously? Thanks Danny.
View Replies !
Deployed Database Change Management
Our company is moving to SQL 2005 and we need to define how we are going to get updates to our clients. We currently use wise installers and I understand that we would be able to shell into sqlcmd in order to run the update scripts. 1. How does sqlcmd handle errors? If a script fails and is rolled back (we are gonna have transactions) how can we notify the installer?2. What is the best practice for scripting changes to a database for deploying on a customers site? Is each change to the schema or objects scripted and if so how is this managed? How does the installer then use these scripts in transactions? Is it possible to have a script call a separate script and if so how can they be aware of failure for rollback?3. Are there any tools that automates the process and makes it easy for management? Thanks B
View Replies !
Where Is My Databases In The MS SQL Express Management Tool?
Where is my databases? I have 2 different DotNetNuke installations on this machine running very well but in the db management tool I cannot find my databases ... I am positive that they are there somewhere collection/holding data but why doesn't they appear in the SQL Express management tool? My connection string is the classic: which says there should be at least one databse --> Database.mdf Doesn't this .mdf file appear in the SQL Express management tool ? Se picture of my control view /Johan
View Replies !
Management Studio Lists All Databases
I was under the impression that Management Studio wouldn't list any databases that a user doesn't have access to. But if I create a new user and give them db_owner permissions to just one database, if they log into Management Studio, they are able to see all databases listed. They don't have access to do anything further, but they can still see the list which I thought was handled better in 2005.
View Replies !
Can't Create Databases In Management Studio
I seem to be having a number of problems using managment studio (MS) against my locally installed SQL 2005 Standard Edition. E.g. when I create a default database using MS it says... TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The server could not load DCOM. (Microsoft SQL Server, Error: 7404) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=7404&LinkId=20476 However, the hyperlinks are less than helpful. I also get problems doing various maintance work from MS. I don't think its a database engine problem 'cause I can do all the work via TSQL DDL but the interface is so much easier to use (or should be). BTW it's running on XP Pro (firewall problem?).
View Replies !
Change Sql Server 2000 Enterprise To Standard Edition
Hi, One of our main servers running on SQL Server 2000 Enterprise edition which has transactional replications on it which replicates to other servers running on the SQL Server 2000 Enterprise edition as well. Due to Hardware problems the server is being migrated to a new machine but the client has installed SQL Server 2000 standard edition on the new machine. We will be using a two processor cpu with 4GB RAM and we are also not planning about clustering. Is there any problem if i migrate the server in Standard Edition will the replications work properly between Standard and Enterprise editions. What other complications can be there if i switch over to standard edition from enterprise edition Thanks in ADVANCE Jacx
View Replies !
SQL Server 2000 Connection Issues After Domain Change
This week we are migrating our servers from one domain to another. We have SQL Server 2000 installed on two cluster servers running MS Server 2000 . After migration I updated the registry with the new IP addrerss per MS instructions on migrating a cluster to a new IP address. We began testing custom applications connecting to the database with OLEDB. There were no issues with these. Database connections were OK. We then tested SQL Server reporting services on a different web server. The server reported that it could not open a connection the report database which was on the cluster DB server. Additionally, several ASP Web applications on the same server were also failing to connect to the database server. This cluster was working properly before migration €“ as far as I know only the IP address was changed and some security patches applied. Server names did not change - just domain. I€™ve been investigating this over the past two days but have failed to resolve the issue. Some things I have learned so far €“ I can connect to the database from several PCs/Servers via ODBC if I use named pipes, but it always fails with TCP/IP. As best as I can tell the cluster server is set to use both Named Pipes and TCP/IP but I don€™t see any indication in the error log that it is listening on TCP. Although I don€™t see that on the similar development cluster server log either and I can connect to that one via TCP/IP. I copied the report server database to another SQL server and was able to connect and run reporting service from ltzamrweb01. Just wanted to make sure that nothing was wrong on the Web end. I can connect from the Web server to the cluster database via ODBC. The error the applications are returning is €œSQL Server does not exist or access denied€? tried removing and re-adding TCP/IP as a listening protocol and also tried changing from standard 1433 port - no success.
View Replies !
|
TRACKER
