Prevent SQL Connections During Database Schema Upgrade
Hello,
We utilise SQL scripts, executed via sqlcmd.exe, to upgrade the schema and common data of our database(s) when we deploy new versions of our software to a production site. At the moment we simply wait until after hours to do the upgrade and ask nicely for all users to not use the system for a while.
Obviously, asking nicely doesn't always work, and there is also the issue of scheduled server tasks and web services / web sites that operate against the database 24/7.
What are our options for putting the entire server (or preferrably just one database) into a semi-offline state so that users and services cannot connect to it while our script connects and performs the upgrade? I imagine there may be several approaches each with their own pros and cons.
If you could point me in the right direction or perhaps mention what strategy has worked for you, it would be greatly appreciated. We perform these upgrades from hundreds of kilometers away via VPNs and Remote Desktop so we can't just unplug the network cable :).
Thank you.
Regards,
- Jason
View Complete Forum Thread with Replies
Related Forum Messages:
How Do I Upgrade An Existing Database Schema?
I have written some software using .NET 2.0, a WinForms app, which uses SQL Server Express as a database. Although I've done my best to set up the database to take into account all of the features, etc., after releasing the first version, I need to make some changes to the database schema, but want to do so without wiping out the entire database for existing users. How do I go about upgrading the database schema for users who are already using the software? I'm thinking I should start by writing a helper app to do so whose sole purpose is to upgrade the schema. The app would be run at install-time, but I don't have any idea how to actually upgrade the schema. I am using C++/CLR .NET, but examples in other .NET languages are more than welcome. Any help is greatly appreciated. Thanks!
View Replies !
Available Strategies To Upgrade A Database Schema Without Downtime
There is a great book on database refactoring that contains a comprehensive set or recipies on how to revise databases that are supposed to be always online and may have various clients that can't be upgraded at the same time. I guess this is a typical case with large databases and I would be surpised if Amazon stops their servers just to move a column from one table to another. The book describes necessary steps for such changes. Basically it's all about creating intermediate database schemas that would be used during transition period. For example, if we need to move a column from one table to another: Version 1. Table A columns: Name, Price Table B columns: Quantity, Date Let's say we move Price to table B: Version 2. Table A columns: Name Table B columns: Quantity, Date, Price The book suggests an intermediate version: Version 1_2. Table A columns: Name, Price Table B columns: Quantity, Date, Price Additional trigger that will synchronize "Price" columns between A and B. Version 1_2 can be used by both clients written for version 1 and 2. Software developers don't need to rush their upgrades, transition can last months and include several changes. This technique requires accuracy in version control management, but looks very good to implement non-interruptible database schema upgrade. I wonder if this is the only option available for data schema upgrade with no downtime. I can't think about anything else - it this how large data warehouses updata their databases?
View Replies !
Can't Read Connections Drop Down In Schema Compare Using DB Pro
Hi,I am using Team Edition for Database Professionals Add on for Visual Studio Team Suite (aka DataDude). If I use Schema Compare, the drop down lists to select Source Schema and Target Schema are messed up. They are unreadable - the text for the drop down lists are shifted up and to the right so far that you only see the bottom corner of the text.I have a coworker who is experiencing the same issue, so I know its not just my local environment. Is there any fix for this bug?Thanks,Graham
View Replies !
DB Upgrade/Schema Changes
Hi, trying to affect schema changes on an SQL DB using however Im encountering a number of errors when trying to do this. Changes are are affected by running a consecutive number of scripts against the DB, see example of script below: -- PREVIOUSDBVERSION=2.8.2.5 -- The above line must be present in all Upgrade SQL files to catch any gaps in the upgrade chain. -- --ALL -- SET NUMERIC_ROUNDABORT OFF GO SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON GO IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID('tempdb..#tmpErrors')) DROP TABLE #tmpErrors GO CREATE TABLE #tmpErrors (Error int) GO SET XACT_ABORT ON GO SET TRANSACTION ISOLATION LEVEL SERIALIZABLE GO BEGIN TRANSACTION GO PRINT N'Dropping Stats from A DB' GO DECLARE @tblname sysname, @statname sysname, @sql nvarchar(2000) DECLARE c CURSOR FOR SELECT object_name(id), name FROM sysindexes WHERE INDEXPROPERTY(id, name, 'IsStatistics') = 1 OPEN c FETCH NEXT FROM c INTO @tblname, @statname WHILE @@FETCH_STATUS = 0 BEGIN SET @sql = 'DROP STATISTICS [' + @tblname + '].[' + @statname + ']' PRINT @sql EXEC (@sql) FETCH NEXT FROM c INTO @tblname, @statname END CLOSE c DEALLOCATE c GO IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION GO IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END GO The database I am upgrading has a growth limit of 2GB, when running the scripts against the DB two things are happening. 1) DB size begins to increase rapidly and eventually breaches 2GB mark 2) LDF file swells to upto 3GB My first thought is that the schema changes are gathering in the log file and not being commited to the DB, or that there is some kind of open transaction that the script is constantly trying to execute over and over. Would like to point out im a novice SQL user, if the information above is sketchy please dont hesitate to say and I will endeavour to provide you with more accurate information. Cheers
View Replies !
The 'System.Web.Security.SqlMembershipProvider' Requires A Database Schema Compatible With Schema Version '1'.
Locally I develop in SQL server 2005 enterprise. Recently I recreated my db on the server of my hosting company (in sql server 2005 express).I basically recreated the tables and copied the data in it.I now receive the following error when I hit the DB:The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.I heard something about running aspnet_regsql.exe, but I dont have that access to the DB. Also I dont know if this command does anything more than creating the membership tables and filling it with some default data...Any other solutions/thought on what this can be?Thanks!
View Replies !
SQL 6.5:Upgrade Of Schema And Load Data-SQL 7.0 ?
Hello, I posted this to the SQL 6.5 formum, but wondered if any here would have an opinion. Thanks In advance to all for any help. Brian ************************************************** ************************* Hello, I am new to this forum. I am a Microsoft Certified Trainer, and Consultant. I was recently contacted by one of my former students that wants some consulting work from me. Here is the situation: This customer provides database development and onsite maintenance service to an insurance company here in Boston. What they do is track the large client portfolios in a large 200-400MB database. The db and table schema changes on an infrequent basis(quarterly but lately more and more). When it does they need to migrate the existing data into the changed db(new schema). They currently do this as follows: 1. Backup existing db 2. Create new db_2 3. Drop db(original) 4. Recreate db(original) empty 5. Thru a series of scripts they: 1. Create the new DB objects)reflecting the changed DB schema) 2. Transfer the data in DB_2 into the changed db (from setp 1 above.) 3. Create new Views and Stored Procedure and Trigger by running scripts. The db is now modified to relect the latest and greatest db schema and the existing data which can now be utilized in new ways. They want from me a set of procedures or automated tasks that will ensure that the creation of the new schema and transfer of data into the new schema works correctly and reports any errors. They are doing this now. It works. Their transfer scripts use INSERT INTO statements to move the data. They want to verify that the process works correctly. The perform this update on a quarterly basis, but lately its happening more often. My question(s) is: 1. Can this be done a better way 2. I have looked at V 7.0 and DTS, is it worth migrating the db to V7 and then create a package to send the newly changed(schmea) and popluated database back to V6.5. 3.What is you advice for this kind of changed db scenario. Thank You in Advance, Brian McCaig --------------------------------------------------------------------------------
View Replies !
Database Schema Compatible With Schema Version '1'
Hello everybody!I'm using ASP.NET 3.5, MSSQL 2005I bought virtual web hosting .On new user registrations i have an error =(The 'System.Web.Security.SqlMembershipProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version. On my virtual machine it work fine but on web hosting i have an error =(What can you propose to me?
View Replies !
Need To Prevent Database Assembly Creation
On certain servers, I don't want developers to be able to create assemblies. Unfortunately, the command sp_configure 'clr enabled', 0 only prevents the CLR-type from being executed, not its creation. I am unable to rename nor put triggers on sys.assemblies, sys.assembly_modules, sys.assembly_files, and sys.assembly_references . I would prefer the user know the boundaries well before implementation. Has anyone succeeded at this?
View Replies !
How To Prevent The Insertion Of The Same Entry Of An Unique Value Into The Database
how to prevent the insertion of the same entry of an unique value into the database? assume that I have a primary key username " abc" in the database and then I insert the "abc" again ,the debuggging error msg pops out saying the primary key cannot be duplicated.. how can I do an if--else statement to check the database against this unintentional inputs of the same unique data " abc"???
View Replies !
How Prevent The Local Administrator To Read The Content Of The Database
Hi everybody, I have an application in dotnet that uses sql express. This application will be deployed on the user computer and I have to find a way to prevent the user to be able to read the data and access the structure of the database. Is there a way to do this ? Even if the user is a local administrator of the computer ? That's a difficult question, isn't it ? ;-)))) Thank you for your possible ideas, Ciao, Aurore
View Replies !
How To Prevent System Administrator To View And Edit A Database Structure And Data
I represent a software development house and we have developed a client server system based on SQL Server. Most of our customers have already purchased Enterprise License of SQL Server, therefore they own the SA Login and Password. We are bound to attach our Database with their Server on their machine. My question is how can we stop a System Administrator of SQL Server to view our Database Structure, Queries, Data installed on their SQL Server on their machine. Our database structure is a trade secret and we cant reveal the structure to the client. please answer this question by email to me at farhandotcom@gmail.com Thanks & Regards Farhan
View Replies !
Northwind Database In SQL Server Express Is Busted And Gone,after SqlCommand Fails In VB2005Express-How To Prevent It Happen?
Hi all, I tried to use dbo.tables of Northwind database in SQL Server Express to do SqlCommand to populate a DataTable in DataSet. The SqlCommand failed in the project execution and I found that Northwind database in SQL Server Express is busted and gone (just the name "Northwind" remained in the SQL Server Management Studio Express). How can I prevent it from happening in my "SqlCommand-SqlConnection" project? Please help and advise. I tried to repair my "Northwind" database by using the SQL2000SampleDb.msi of Northwind and pubs Sample Databases for SQL Server 2000 downloaded from the http://www.microsoft.com/downloads. My "pubs" database is still in my SQL Server Management Studio Express. How can I just repair my "Northwind" database by using the Microsoft SQL2000SampleDb.msi program? Please help and advise this matter too. Thanks in advance, Scott Chang
View Replies !
SELECT Permission Denied On Object 'TableID', Database 'Database', Schema 'dbo'
The error message: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'TestID'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors The log file reads: ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'TestID'. ---> System.Data.SqlClient.SqlException: SELECT permission denied on object 'TableID', database 'Database', schema 'dbo'. ***Background*** General Users got an error message when trying to access any reports we have created. All admin have no problems with the reports. Users (Domain Users) are given rights (Browser) to the reports and the Data Sources (Browser) and yet cannot view the reports. An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'DS2'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors I'll add this from the report logs... w3wp!processing!1!3/20/2007-11:43:25:: e ERROR: Data source €˜DS2€™: An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source €˜DS2€™. ---> System.Data.SqlClient.SqlException: Cannot open database €œDatabase€? requested by the login. The login failed. Login failed for user €˜DOMAINUsername€™. The user has rights via a local group to the report and data source (Browser rights) and the local group has been added as a SQL login. I gave rights to the databases themselves instead of just to SQL and the error changed (Ah-ha...progress, but why!?!?)
View Replies !
SELECT Permission Denied On Object 'TableID', Database 'Database', Schema 'dbo'
The error message: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'TestID'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors The log file reads: ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'TestID'. ---> System.Data.SqlClient.SqlException: SELECT permission denied on object 'TableID', database 'Database', schema 'dbo'. ***Background*** General Users got an error message when trying to access any reports we have created. All admin have no problems with the reports. Users (Domain Users) are given rights (Browser) to the reports and the Data Sources (Browser) and yet cannot view the reports. An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'DS2'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors I'll add this from the report logs... w3wp!processing!1!3/20/2007-11:43:25:: e ERROR: Data source €˜DS2€™: An error has occurred. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source €˜DS2€™. ---> System.Data.SqlClient.SqlException: Cannot open database €œDatabase€? requested by the login. The login failed. Login failed for user €˜DOMAINUsername€™. The user has rights via a local group to the report and data source (Browser rights) and the local group has been added as a SQL login. I gave rights to the databases themselves instead of just to SQL and the error changed (Ah-ha...progress, but why!?!?)
View Replies !
The Database Principal Owns A Schema In The Database, And Cannot Be Dropped.
Trying to get my hands around all the new security features of SQL Server 2005. In Management Studio did something I don't know how to undo. I added a database role ReadOnlyRole and clicked the box next to db_datareader in the owned schemas box. Then I tried to remove the ReadOnlyRole and could not. How do I undo what I did? Is it possible? The below is the TSQL that generates the my issue. Use [master] go create database [test] go USE [test] GO CREATE ROLE [ReadOnlyRole] GO USE [test] GO ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO [ReadOnlyRole] GO drop role [ReadOnlyRole] go
View Replies !
Help For Database Schema
Hello All, My project uses MS SQL server database and is not too big database (have aound 200 table). Now I have to create Database schema for my database as my project needs to be integrated with some other product. I don't know much about database schema and how to start with it. Can someone please give me some inputs on following: 1) What exactly database schema should include? 2) How should I start creating the schema for my database? 3) Are there any tools for doing this? Thanks in advance
View Replies !
How To Get All Database Schema?
hello, here is my problem. I have to rebuild database after crash. there is no backup. So I did a bcp to get data from. But I do not have the original database so my question is how to get the full schema off the data base, tables,colomns,stored procedures etc... thanks lot for any help.
View Replies !
Database Vs Schema
We currently have a product in which each client has their own Database. We adjust the connection when a user for that client logs into the system. This system has continued to grow and a good pace, but we have come to a point where failover is taking too long. Refactoring the Database to handle multiple sites in a single database is not an option because of the time it would take to make the change. So, we are looking for another way in which this could be handle. One idea is to take multiple clients and place them in a single database using a schema to seperate them. (ex. Client A = server1.db1.schema1, Client B = server1.db1.schema2, etc). Is there another option that would be better, or what kind of performance can we expect if we follow this path? Or, is there a way to decrease the failover time (it appears the problem is the startup of the database on the failover server)? Thad
View Replies !
RS Database Schema?
We have a RS 2000 server with a over a hundred reports, and about half as many weekly and monthly subscriptions. In reply to my request to upgrade to RS2005, the boss asked me today for a compete list of the reports, who subscribes to them, and their delivery frequency. He was not interested in paying for a VB or C# development effort with the SOAP API that it would require to obtain a simple list from a SQL server database, since he already has SQL programmers on staff. So how can I get this list? Anyone know of any demo code out there? Forgive my sarcasm and Thanks in advance. Herb
View Replies !
Changes To Database Schema
Does anyone know which database table/view one can query to get a list of all objects that have been changed by users accessing a database? Is there any? or is there some other way of doing this?
View Replies !
Sql Database Schema
Hi. I would like to retrieve the table names of a database, the column names nad its contraints of each table in a database.. How can this be achieved???
View Replies !
Replication Of The Schema Of A SQL Database
Hi all, I am doing a replication of a SQL Server 2005 database from one server to another server, everything worked fine. Now, when I added some fields to this database, the replication stopped. can I do replication of a schema of a SQL database? how? Should the replication work even if I add some fields.
View Replies !
SQL Database Schema Sync
SQL Database Schema Sync We have development and production databases, when we change database schema in development database how can I synchronize it to production without creating data problems in production, is this possible in SQL2005? Or any external tool I can use?
View Replies !
Exporting Database Schema
Is there a way for VS2005 to export the database schema of a .mdf into a .sql file? Preferably from a Web PRoject, not a Database Project, but right now I am anything but picky, so whatever works. Thanks.
View Replies !
Database Schema Conversion
Hello all,I am doing some research on database conversions. Currently, I aminterested in any information that would help me convert a database fromone schema to another. This could be changes as minimal as adding afield to a table, or as large as deleting tables and changingrelationships. Unfortunately, my experience with SQL Server is minimal.I know how to do a lot, but I do not know a lot of intricacies thatmost experts know. I know how to add tables, delete them, alterrelationships, add fields, work with stored procedures, take care ofsecurity, etc. I also know how to backup, restore, etc.The type of information I am looking for could be:1) Open source software that performs conversions2) Tutorials/books/<any reference> that would assist me in learningwhat I must to complete this task.3) Third party software that could be used on a large scale andwouldn't resort in unnecessary licensing cost if I was to deploy on thislarge scale.I greatly appreciate any information that could be provided me.To give you guys an idea of my experience level:I've been programming C# and .NET for a year now. I've also hadextensive experience in object-oriented design. I've worked with visualbasic, cobol (did I mention this? LOL), asp.net, php, javascript, andseveral other programming languages on an extensive basis. Whileprogramming is my speciality, I've strayed away from database work untilnow. I would greatly appreciate any assistance in researching this matter.Thanks ahead guys,Shock
View Replies !
Database Schema Designing
Case 1: A company is involved into e-commerce..hosting multiple websites for different products. CAse 2: The above scenario could also be implemented with a single site having multiple products for sale. For Case 2 one would go for a single database for all the products. While for CAse 1 ,a separate Database is developed for each Site. What I fill is CAse2 is a more appropriate choice even if we have multiple sites for different products. This would help us in rapid development of any ecommerce site... ANd better ERP management for the Company. I would appreciate some expert guidelines for the above scenario Thanx in Advance Warm Regards Girija
View Replies !
Upgrading A Database Schema
I am trying to find a utility that will compare 2 SQL Server database schemas and produce a DDL script that will allow one of the databases to be upgraded to match the other database. I have found a tool that will compare 2 database schemas and output the differences but it won't produce the DDL commands to upgrade one of the databases. You can use Enterprise manager to produce database scripts for both databases and then compare the scripts but again this does not produce the DDL code. If anyone knows of such a utility can they let me know. Or if they know of an easy way of doing this.
View Replies !
Database Schema Exported......
MS SQL 6.5 NT I have been asked to export the database schema (containing table names, field names, data types, field lengths, field defaults, nulls, etc) to an MS Excel spread sheet. "sp_help filename" provides some data but the format is difficult to manage. All help with this matter would be greatly appreciated.... Thanks in advance.
View Replies !
Database Schema Creation
Although this isn't really an ASP question it is pretty advanced. Well at least in my opinion it is. I am creating an articles page. Where someone will write articles online via a form and put the articles into a database. Here is simplified database schema for the articles. Name of Table: ArticleInfo field Name: articledate - datetime field Name: articlenumber - auto-incremented field field Name: articletitle - varchar field Name: articlemessage - text I am developing this using SQL Server as a backend. What my question is about creating the auto-increment field. I want to have two primary keys together that will identify a single row, namely articledate and articlenumber. ArticleNumber is basically the count of that article for that date. For example a sample database would look like this: no articletext and articletitle's displayed here but just the other two columns: articledate articlenumber 1/1/2000 1 1/1/2000 2 1/2/2000 1 1/3/2000 1 1/4/2000 1 1/4/2000 2 1/4/2000 3 As you can see I want the articlenumber field to start over auto-incrementing with each new unique articledate inserted into the table. I hope you understand what I am trying to do. How do I create this schema in SQL Server? Using triggers? I have thought about trying to write a stored procedure with the following code -check if that date exists already in the record -then use the identity function which allows you to specify a beginning increment value if the date does not exist but I would need to lock the table so that concurrent articles wouldn't mess up the articlenumber. what i mean is if no articles existed for that date and I have two seperate authors entering information for that date then it is possible the stored procedure might give both articles the articlenumber of 1 since none existed before and they are simutaenously entering data. is there a better way to do this? i hope you understand my database schema and my problem!
View Replies !
Copy The Database Schema
Hi, Can anyone help me to figure out how to generate the SQL Script that can produce the same database schema with the existing database? I have tried the "Generate SQL Script" tool. However, it only creates the object such as tables, stored procedures, triggers and etc. I still have to create the database first in order to run that script. I have an existing database that has a 2.7 GB size (let's called this ABC Database). In a different server, I would like to create the same database with the ABC DB without having to restore the ABC DB. Bottom line, I would like to see the script creates the database along with all stored procedures, triggers and the size of the database will be 2.7 GB. Is it possible? Thank you very much! Jane
View Replies !
Database Schema Comparison
Hello all. I am using Sql Compact Edition for a small standalone application, I create and build the initial database schema on initial startup. What I am looking for is a way to upgrade the software and on initial startup of the new version, I would like it to compare the existing database with a new schema and then update the database based on the difference. This way I can have a version that will update the database without me having to know what version it is to begin with. Is there a way to do this or am I asking too much? Thank you, Jim
View Replies !
What 's The Database Schema 's Usage?
database schema seems just a tag ? I have found some materials about schema, they said ,schema is seperated from owner. But , no materials are talking about what things schema can do / how to programming with schema.
View Replies !
Obfuscate Database Schema
I can't believe I am asking this but I have been "requested" to. Scenario: Database based app installed on client site Goal: Protection of database schema. Solution: Obfuscate? - Any tools available? Host db in secure location - Not going to happen! Any thoughts? DavidM Production is just another testing cycle
View Replies !
Copying The Database Schema
Hi Friends We have a database that contains tables having 4 million records Can you tell me a way to copy the schema of the Database to a new database. Generate SQL Script...Is it the only option or can i use the DTS package Which is the most reliable one? Regards Vivek Vic http://vicdba.blogspot.com
View Replies !
Database Connections
Hi all, I am fairly new to mobile development and im trying to write a simple application that can read, write from a SQL Server Mobile Database and load data into a list view. The problem im having is trying to find examples on how to do this and i cant seem to get many of the ones i find to work properly. Im still use to recordsets and adodb and if anyone has any examples on how to do this that would be great. Also, would it possible if someone could explain this code to me as well Dim conn As SqlCeConnection = Nothing Dim cmd As SqlCeCommand = Nothing Dim rdr As SqlCeDataReader = Nothing Try ' Open the connection and create a SQL command ' conn = New SqlCeConnection("Data Source = AdventureWorks.sdf") conn.Open() cmd = New SqlCeCommand("SELECT * FROM DimEmployee", conn) rdr = cmd.ExecuteReader() ' Iterate through the results ' While rdr.Read() Dim employeeID As Integer = rdr.GetInt32(0) ' or: rdr["EmployeeKey"]; Dim lastName As String = rdr.GetString(5) ' or: rdr["FirstName"]; End While ' Always dispose data readers and commands as soon as practicable ' rdr.Close() cmd.Dispose() Finally ' Close the connection when no longer needed ' conn.Close() End Try Thanks byeadon
View Replies !
Create Database Models From XML Schema (.xsd)
Hi .Net Guru’s,I have an urgent requirement for my project; the issue is mentioned below;Using .Net(C#/VB.Net) I need to generate/created Database objects from XML schemas.I don't have any sample xml schema file to give you. You just imagine you have a sample .xsd file and this .xsd file will be used to create database tables.Please let me know if you have any queries. Thanks,nick
View Replies !
Does Anyone Use SSIS For Database Schema Maintenance?
We currently use SSIS to build DTS packages in which we store changesto our database schema, as well as scripts that need to be run uponeach release. This works well for small sets of changes that neverneed to be updated or for architectures with only one database.We store each of the changes included in the package in separatefiles, which are tracked using version control. It is growing timeconsuming to maintain parity between those files and what is in theSSIS.Furthermore, we have been unable to discover an easy way to load afile's contents into a package SQL Task without opening the file andcopy-pasting the contents into a new SQL task.ANY information at all would be extremely appreciated!
View Replies !
Database Schema Access Rights
Hello all, Does anybody have an answer to this: Can a user, with less then dbo rights, be granted specific right to view the db schema? I think not not, because the schema does not have "read only" option, but I am challenged to come up with a solution and I could not find a hint so far. Thank you very much. Boris
View Replies !
|
TRACKER
