473,396 Members | 1,891 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

copy users on server to another - SQL 2005 SP2

I've built a development server for my SQL 2005 production
environment. I've restore the databases from a backup, and I want to
copy the users from my production to development machine.
How can I do this?
TIA
Rob

Aug 27 '07 #1
2 4713
One way is to use Transfer Login Task through SSIS
Thanks
Shiju Samuel

On Aug 27, 9:20 pm, rcamarda <robert.a.cama...@gmail.comwrote:
I've built a development server for my SQL 2005 production
environment. I've restore the databases from a backup, and I want to
copy the users from my production to development machine.
How can I do this?
TIA
Rob

Aug 27 '07 #2
On Aug 27, 1:35 pm, Shiju Samuel <shiju.sam...@gmail.comwrote:
One way is to use Transfer Login Task through SSIS
Thanks
Shiju Samuel

On Aug 27, 9:20 pm, rcamarda <robert.a.cama...@gmail.comwrote:
I've built a development server for my SQL 2005 production
environment. I've restore the databases from a backup, and I want to
copy the users from my production to development machine.
How can I do this?
TIA
Rob
thanks! that did the trick!

Aug 27 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Mr Gabriel | last post by:
Hi to all, I'm trying to use the copy database wizard to copy a database from the 2000 version to the 2005 version of sql server. I choose not to copy logins so I expect to find a database with...
1
by: Byron | last post by:
Hi, I have(had) an old Win2k Server server with about 30 web site databases (SQL 2000) that just went under due to hardware problems. Thankfully, I have backups of all the databases plus the MDF...
1
by: Paolo | last post by:
I have been following a few walkthroughs that came with VS 2005, and they work fine (I had to change the machine.config files to work with my SQL 2005 Pro version, instead of the SQL 2005 Express)....
2
by: Rico | last post by:
Hello, I have an ASP web app with an SQL back end. I am currently migrating to a new Windows 2003 Server machine and SQL Server 2005 Express. When I import the old database, I'm trying to...
6
by: sql_server_user | last post by:
I'm trying to copy all 440 million rows from one table in my SQL Server 2005 db to another table with a different clustering scheme. After a few test inserts that were successful (up to a million...
6
by: Thanks | last post by:
Two Windows 2003 server, one with SQL 2005 server, another with SQL Express. Is it possible to copy databases from SQL 2005 to SQL Express? Thanks.
5
by: Steve | last post by:
Hi; I thought I would rephrase a question I asked in another post to more quickly get to the heart of the matter. My apologies for anyone who is offended by what appears to be a repetition. ...
9
by: fniles | last post by:
I would like to copy a table(s) from SQL Server 2005 to a CVS file and vice versa. I was thinking to use the BCP command line utility, but I have a few questions: 1. The machine where I am...
1
by: ll | last post by:
Hi, I have copied a MS SQL database to my local machine and am testing it with ASP pages, locally, on IIS. I have a db connect page that keeps the current connections for the live database. My...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.