database restore from production to development

Hi,
I am in the process of overlaying our development data
with production backup. The users are different in prod as
compared with dev. My concern is if I restore production
copy on to dev, it might overwrite the sysusers info in
dev. I don't want to a) add prod users onto dev and b)
remove existing users in dev after the restore.
How do I keep my sysusers info intact ?
Currently I am thinking of
a) Get all users from dev and keep it aside
b) Restore the production onto dev
c) Delete all users in dev
d) Add users from (a) to dev
Will this work ? are there any other ways ?
TIA
MohanHave you looked at sp_change_users_login?
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mo" <anonymous@.discussions.microsoft.com> wrote in message
news:d7c301c3ef32$7c071cb0$a501280a@.phx.gbl...
> Hi,
> I am in the process of overlaying our development data
> with production backup. The users are different in prod as
> compared with dev. My concern is if I restore production
> copy on to dev, it might overwrite the sysusers info in
> dev. I don't want to a) add prod users onto dev and b)
> remove existing users in dev after the restore.
> How do I keep my sysusers info intact ?
> Currently I am thinking of
> a) Get all users from dev and keep it aside
> b) Restore the production onto dev
> c) Delete all users in dev
> d) Add users from (a) to dev
> Will this work ? are there any other ways ?
> TIA
> Mohan
>|||Mo,
A way would be scripting out all database users on the development server
and run this script every time you restore the production backup. You can
create a sql agent job that restores the database and then runs this script
as an additional step.
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Mo" <anonymous@.discussions.microsoft.com> wrote in message
news:d7c301c3ef32$7c071cb0$a501280a@.phx.gbl...
> Hi,
> I am in the process of overlaying our development data
> with production backup. The users are different in prod as
> compared with dev. My concern is if I restore production
> copy on to dev, it might overwrite the sysusers info in
> dev. I don't want to a) add prod users onto dev and b)
> remove existing users in dev after the restore.
> How do I keep my sysusers info intact ?
> Currently I am thinking of
> a) Get all users from dev and keep it aside
> b) Restore the production onto dev
> c) Delete all users in dev
> d) Add users from (a) to dev
> Will this work ? are there any other ways ?
> TIA
> Mohan
>

database restore from production to development

Hi,
I am in the process of overlaying our development data
with production backup. The users are different in prod as
compared with dev. My concern is if I restore production
copy on to dev, it might overwrite the sysusers info in
dev. I don't want to a) add prod users onto dev and b)
remove existing users in dev after the restore.
How do I keep my sysusers info intact ?
Currently I am thinking of
a) Get all users from dev and keep it aside
b) Restore the production onto dev
c) Delete all users in dev
d) Add users from (a) to dev
Will this work ? are there any other ways ?
TIA
MohanHave you looked at sp_change_users_login?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mo" <anonymous@.discussions.microsoft.com> wrote in message
news:d7c301c3ef32$7c071cb0$a501280a@.phx.gbl...
> Hi,
> I am in the process of overlaying our development data
> with production backup. The users are different in prod as
> compared with dev. My concern is if I restore production
> copy on to dev, it might overwrite the sysusers info in
> dev. I don't want to a) add prod users onto dev and b)
> remove existing users in dev after the restore.
> How do I keep my sysusers info intact ?
> Currently I am thinking of
> a) Get all users from dev and keep it aside
> b) Restore the production onto dev
> c) Delete all users in dev
> d) Add users from (a) to dev
> Will this work ? are there any other ways ?
> TIA
> Mohan
>|||Mo,
A way would be scripting out all database users on the development server
and run this script every time you restore the production backup. You can
create a sql agent job that restores the database and then runs this script
as an additional step.
--
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Mo" <anonymous@.discussions.microsoft.com> wrote in message
news:d7c301c3ef32$7c071cb0$a501280a@.phx.gbl...
> Hi,
> I am in the process of overlaying our development data
> with production backup. The users are different in prod as
> compared with dev. My concern is if I restore production
> copy on to dev, it might overwrite the sysusers info in
> dev. I don't want to a) add prod users onto dev and b)
> remove existing users in dev after the restore.
> How do I keep my sysusers info intact ?
> Currently I am thinking of
> a) Get all users from dev and keep it aside
> b) Restore the production onto dev
> c) Delete all users in dev
> d) Add users from (a) to dev
> Will this work ? are there any other ways ?
> TIA
> Mohan
>

Database Releases

I'm looking for documentation templates to specify releases or promotions of
items from Dev to QA to Prod. Has anyone got any recommendations or
references to some that already exist?
Thanks - Craig.Hi
If you have a bug tracking system and version control this can be done
process that combines labelling fixes and extracting the appropriate version
from the repository. Exactly how depends on what systems you are using. There
may be some white papers on the web sites for these sort of products such as
Serena (formally Merant PVCS).
John
"Craig" wrote:
> I'm looking for documentation templates to specify releases or promotions of
> items from Dev to QA to Prod. Has anyone got any recommendations or
> references to some that already exist?
> Thanks - Craig.|||Thanks for the reply. I was hoping to locate a MS Word template that might
aid in this effort.
- Craig
"John Bell" wrote:
> Hi
> If you have a bug tracking system and version control this can be done
> process that combines labelling fixes and extracting the appropriate version
> from the repository. Exactly how depends on what systems you are using. There
> may be some white papers on the web sites for these sort of products such as
> Serena (formally Merant PVCS).
> John
>
> "Craig" wrote:
> > I'm looking for documentation templates to specify releases or promotions of
> > items from Dev to QA to Prod. Has anyone got any recommendations or
> > references to some that already exist?
> >
> > Thanks - Craig.|||Hi
Sorry I didn't read "template"!
If you are looking for a process then it will depend on the systems and
configurations that you are using, therefore I would not really expect it to
fit a generic template.
I would assume that you already have some form of process that you can then
reverse engineer and then formalise/improve?
John
"Craig" wrote:
> Thanks for the reply. I was hoping to locate a MS Word template that might
> aid in this effort.
> - Craig
>
> "John Bell" wrote:
> > Hi
> >
> > If you have a bug tracking system and version control this can be done
> > process that combines labelling fixes and extracting the appropriate version
> > from the repository. Exactly how depends on what systems you are using. There
> > may be some white papers on the web sites for these sort of products such as
> > Serena (formally Merant PVCS).
> >
> > John
> >
> >
> > "Craig" wrote:
> >
> > > I'm looking for documentation templates to specify releases or promotions of
> > > items from Dev to QA to Prod. Has anyone got any recommendations or
> > > references to some that already exist?
> > >
> > > Thanks - Craig.

Database Releases

I'm looking for documentation templates to specify releases or promotions of
items from Dev to QA to Prod. Has anyone got any recommendations or
references to some that already exist?
Thanks - Craig.
Hi
If you have a bug tracking system and version control this can be done
process that combines labelling fixes and extracting the appropriate version
from the repository. Exactly how depends on what systems you are using. There
may be some white papers on the web sites for these sort of products such as
Serena (formally Merant PVCS).
John
"Craig" wrote:

> I'm looking for documentation templates to specify releases or promotions of
> items from Dev to QA to Prod. Has anyone got any recommendations or
> references to some that already exist?
> Thanks - Craig.
|||Thanks for the reply. I was hoping to locate a MS Word template that might
aid in this effort.
- Craig
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> If you have a bug tracking system and version control this can be done
> process that combines labelling fixes and extracting the appropriate version
> from the repository. Exactly how depends on what systems you are using. There
> may be some white papers on the web sites for these sort of products such as
> Serena (formally Merant PVCS).
> John
>
> "Craig" wrote:
|||Hi
Sorry I didn't read "template"!
If you are looking for a process then it will depend on the systems and
configurations that you are using, therefore I would not really expect it to
fit a generic template.
I would assume that you already have some form of process that you can then
reverse engineer and then formalise/improve?
John
"Craig" wrote:
[vbcol=seagreen]
> Thanks for the reply. I was hoping to locate a MS Word template that might
> aid in this effort.
> - Craig
>
> "John Bell" wrote:

Database Releases

I'm looking for documentation templates to specify releases or promotions of
items from Dev to QA to Prod. Has anyone got any recommendations or
references to some that already exist?
Thanks - Craig.Hi
If you have a bug tracking system and version control this can be done
process that combines labelling fixes and extracting the appropriate version
from the repository. Exactly how depends on what systems you are using. Ther
e
may be some white papers on the web sites for these sort of products such as
Serena (formally Merant PVCS).
John
"Craig" wrote:

> I'm looking for documentation templates to specify releases or promotions
of
> items from Dev to QA to Prod. Has anyone got any recommendations or
> references to some that already exist?
> Thanks - Craig.|||Thanks for the reply. I was hoping to locate a MS Word template that might
aid in this effort.
- Craig
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> If you have a bug tracking system and version control this can be done
> process that combines labelling fixes and extracting the appropriate versi
on
> from the repository. Exactly how depends on what systems you are using. Th
ere
> may be some white papers on the web sites for these sort of products such
as
> Serena (formally Merant PVCS).
> John
>
> "Craig" wrote:
>|||Hi
Sorry I didn't read "template"!
If you are looking for a process then it will depend on the systems and
configurations that you are using, therefore I would not really expect it to
fit a generic template.
I would assume that you already have some form of process that you can then
reverse engineer and then formalise/improve?
John
"Craig" wrote:
[vbcol=seagreen]
> Thanks for the reply. I was hoping to locate a MS Word template that migh
t
> aid in this effort.
> - Craig
>
> "John Bell" wrote:
>