If anyone has some knowledge about transitioning the SQL-server
between Prod and Test/Test and Prod then please give me some hints
about it.
Thanx in advance
Tom Stevns Nielsen
Thanx in advance
Tom Stevns Nielsen
Depending on the critically of the app, you might consider establishing
separate environments for development (Dev), system testing (QA), user
acceptance testing (UAT) and production (Prod). The QA and Dev systems
would not necessarily need to be full copies of Prod but the schema in
QA should be the same as Prod before the upgrade scripts are run.
In this scenario, the process is:
1) develop and test scripts in Dev
2) run scripts in QA for iterative testing
3) restore UAT from Prod backup and run scripts
4) run scripts in Prod
BTW, regardless of the method you choose, I suggest you keep your DDL
scripts under source control.
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
Quote:> If anyone has some knowledge about transitioning the SQL-server
> between Prod and Test/Test and Prod then please give me some hints
> about it.
> Thanx in advance
> Tom Stevns Nielsen
1. Transition from Access to SQL Server
It is difficult to find infomormation for the upsizing from access to SQL
server. Are most of the access skills still required in SQL server or is it
a completely new process? Any good KB articles or FAQ's before we make the
jump?
Larry Bowers
Rexroth Mecmam Pneumatics
Lexington, KY
2. A Question on Remote Procedure call in a trigger
3. Transition from Access to SQL Server replication
4. Retrieving SQL Server 7 RaisError Info Within VB App?
5. Transition from ACCESS TO SQL Server
6. newbie Q regarding indexes and identities
7. Support WebCast: Microsoft SQL Server 2000: Reading Execution Plans in SQL Server 2000
8. SQL Server Agent (Multi Server Jobs w/ Maintenance Plans)
9. Minimize Downtime during transition to cluster server
10. transition from Access to MS SQL
11. Transition from Access 2000 to SQL 2000
12. Transition from Access to SQL