transfer Database

[skarosi]

Hi all,
I have created a database on my PC at home using MS SQL Server and i need to transfer it to an other computer with the accounts and passwords. Is that possible, or i have to recreate the account at the other server?

thanks a lot, Ilias

 

[SQLBill]

Go to Microsoft's website and search for KB246133 or sp_help_revlogin. That will provide you a script to run to get the logins, etc. The results will be a script to run on the new server.

-SQLBill

Posting advice: FAQ481-4875

 

[onpnt]

If this is 2005 is would fairly easy to create an SSIS package to perform the task for you also if it will be something that you will be transporting often

[sub]____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[skarosi]

Sorry, i forgot to mension that i have SQL 2000.
Thanks for the tip, i will give it a try
cheers

 

[ptheriault]

Here is an FAQ that I wrote that has sp_help_revlogins for 2000 or 2005.
faq962-6608

After you move the logins you can just detach copy the .msf and .ldf files and attach your database on the server.

- Paul

- If at first you don't succeed, find out if the loser gets anything.