November 7, 2005 at 9:52 am
We have developed and application for a client on our location. And now after the successfull completion of the development we are planning to delpoy the application oN client's location. And as part of that we are planning to create the database instance at client's location. If I generate sql script for jobs and logins on the databse at our location and execute those commands on the client location, will that work fine or do we need to manaually create all the logins and jobs at client location.
Thanks.
November 7, 2005 at 11:59 am
Generating a script for logins, jobs, etc. should work fine (it's also less work than re-creating everything). The clients logins are going to be the same as yours? Also, make sure you script the configuration options too (sp_configure).
A.J.
DBA with an attitude
November 7, 2005 at 12:00 pm
One thing to be aware of is if you have any jobs that reference network paths, etc.
A.J.
DBA with an attitude
November 8, 2005 at 3:45 am
You could always script out your logins and then just backup/restore or detach/attach your database rather than scripting out all of your database tables.. You'll need to use the sp_change_users_login stored proc after the transfer to map logins again.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply