Re: import user list
From: JoeyDBA (JoeyDBA_at_yahoo.com)
Date: 07/22/04
- Next message: Steve Thompson: "Re: import user list"
- Previous message: Brian McCulloch: "import user list"
- In reply to: Brian McCulloch: "import user list"
- Next in thread: Steve Thompson: "Re: import user list"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 22 Jul 2004 13:16:53 -0500
Have you thought about using bcp to copy out from sysxlogins. You can create
a view on the SQL7 server where you don't pull system accounts, such as
'sa'. Then bcp to copy in at your target server? You'd have to turn on the
'update to system tables' for the bcp in to work. Then you execute
sp_change_users_login to map the logins to database.
just a thought.
"Brian McCulloch" <brian.d.mcculloch@citicorp.com> wrote in message
news:236a01c4700c$a22811f0$a301280a@phx.gbl...
> Greetings, All.
>
> I'm importing a database from SQL 7 to 2000. The import
> fails partway through because I don't have all the users
> set up on the 2000 server. I don't see a way to import the
> users from 7. I can export them to a file, however. Is
> there a way to use that file to get them into the 2000
> server? I'm sure I could import the data and write code to
> use existing stored procedures but I'm hoping to avoid re-
> inventing the wheel as I'm fairly confident I'm not the
> only one who's run into this problem.
>
> Thanks,
>
> Brian.
- Next message: Steve Thompson: "Re: import user list"
- Previous message: Brian McCulloch: "import user list"
- In reply to: Brian McCulloch: "import user list"
- Next in thread: Steve Thompson: "Re: import user list"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
