Click here to Skip to main content
14,693,599 members
Home » Discussions » Database
   

Database

 
GeneralRe: Data on one server, structure on another Pin
_Zorro_22-Jul-11 6:17
professional_Zorro_22-Jul-11 6:17 
AnswerRe: Data on one server, structure on another Pin
smcnulty200022-Jul-11 21:58
Membersmcnulty200022-Jul-11 21:58 
GeneralRe: Data on one server, structure on another Pin
_Zorro_25-Jul-11 3:37
professional_Zorro_25-Jul-11 3:37 
GeneralRe: Data on one server, structure on another Pin
smcnulty200025-Jul-11 8:33
Membersmcnulty200025-Jul-11 8:33 
GeneralRe: Data on one server, structure on another Pin
_Zorro_25-Jul-11 23:22
professional_Zorro_25-Jul-11 23:22 
GeneralRe: Data on one server, structure on another Pin
smcnulty200025-Jul-11 9:16
Membersmcnulty200025-Jul-11 9:16 
GeneralRe: Data on one server, structure on another Pin
_Zorro_25-Jul-11 23:24
professional_Zorro_25-Jul-11 23:24 
AnswerRe: Data on one server, structure on another Pin
Mycroft Holmes22-Jul-11 22:24
professionalMycroft Holmes22-Jul-11 22:24 
Still does not make sense to me. Why not take a copy of the procedures and run them on the test server. We use SQL Compare to do this except we do it the other way around. Develop on the dev server, test on UAT and deploy to Production, SQL Compare does the synching of the code in both steps.

When we require another environment we take a backup of production onto yet another server. Then the only change is the server name and we don't use that in the qualification in the code. I admit this may become complicated if you are using distributed databases but we use Oracle for any really big data (multi TB)
Never underestimate the power of human stupidity
RAH

GeneralRe: Data on one server, structure on another Pin
smcnulty200022-Jul-11 22:32
Membersmcnulty200022-Jul-11 22:32 
GeneralRe: Data on one server, structure on another Pin
Mycroft Holmes23-Jul-11 1:03
professionalMycroft Holmes23-Jul-11 1:03 
GeneralRe: Data on one server, structure on another Pin
David Skelly24-Jul-11 23:36
MemberDavid Skelly24-Jul-11 23:36 
GeneralRe: Data on one server, structure on another Pin
_Zorro_25-Jul-11 3:45
professional_Zorro_25-Jul-11 3:45 
GeneralRe: Data on one server, structure on another Pin
Mycroft Holmes25-Jul-11 13:13
professionalMycroft Holmes25-Jul-11 13:13 
GeneralRe: Data on one server, structure on another Pin
_Zorro_25-Jul-11 23:15
professional_Zorro_25-Jul-11 23:15 
GeneralRe: Data on one server, structure on another Pin
Mycroft Holmes25-Jul-11 23:43
professionalMycroft Holmes25-Jul-11 23:43 
GeneralRe: Data on one server, structure on another Pin
_Zorro_26-Jul-11 2:53
professional_Zorro_26-Jul-11 2:53 
Questionset password on database in sql server 2005 Pin
SajjadZare21-Jul-11 23:11
MemberSajjadZare21-Jul-11 23:11 
AnswerRe: set password on database in sql server 2005 Pin
Blue_Boy21-Jul-11 23:24
MemberBlue_Boy21-Jul-11 23:24 
JokeRe: set password on database in sql server 2005 Pin
lw@zi 21-Jul-11 23:27
professional lw@zi 21-Jul-11 23:27 
JokeRe: set password on database in sql server 2005 Pin
Blue_Boy21-Jul-11 23:28
MemberBlue_Boy21-Jul-11 23:28 
GeneralRe: set password on database in sql server 2005 Pin
SajjadZare22-Jul-11 1:24
MemberSajjadZare22-Jul-11 1:24 
GeneralRe: set password on database in sql server 2005 Pin
Blue_Boy22-Jul-11 3:56
MemberBlue_Boy22-Jul-11 3:56 
AnswerRe: set password on database in sql server 2005 Pin
Shameel22-Jul-11 10:19
professionalShameel22-Jul-11 10:19 
QuestionEntity Framework and Default Values [answered] Pin
Pascal Ganaye21-Jul-11 7:33
MemberPascal Ganaye21-Jul-11 7:33 
AnswerRe: Entity Framework and Default Values [answer] Pin
Pascal Ganaye21-Jul-11 23:05
MemberPascal Ganaye21-Jul-11 23:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.