Click here to Skip to main content
14,696,871 members
Home » Discussions » Database
   

Database

 
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 
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 
Mycroft Holmes wrote:
Still does not make sense to me. Why not take a copy of the procedures and run
them on the test server.


Because we're using continuous integration with tfs 2010, and want to launch the test sets while the build server is... building. If we have to copy our stored procedures to the test database then this will require a manual action each time a sp is updated, which I think, is a bad idea. Less humans around, less problems.

Apart from checking bugs, we'd also like to guarantee that the deploy succeed regardless of the environment (dev, tst, post test, production).

I know this seems a bit strange since we should only test on one of those, but we have numerous errors due to deployment issues (large amount of files to merge, a lot of manual actions) and we'd like to prevent that, or at least, be warned as soon as possible.

Thanks
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 
QuestionHow to do a select statement from two or more tables? Pin
eight21-Jul-11 0:27
Membereight21-Jul-11 0:27 
AnswerRe: How to do a select statement from two or more tables? Pin
Blue_Boy21-Jul-11 0:43
MemberBlue_Boy21-Jul-11 0:43 
GeneralRe: How to do a select statement from two or more tables? Pin
eight21-Jul-11 0:51
Membereight21-Jul-11 0:51 
GeneralRe: How to do a select statement from two or more tables? Pin
Blue_Boy21-Jul-11 1:58
MemberBlue_Boy21-Jul-11 1:58 

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.