sql server new users:
These should help:
Moving Server/Database/Logins
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs=20
http://www.support.microsoft.com/?id=3D314546 Moving DB's between =
Servers
http://www.support.microsoft.com/?id=3D224071 Moving SQL Server =
Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=3D221465 Using WITH MOVE in a =
Restore
http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththei= rdatabases.asp Moving Users
http://www.support.microsoft.com/?id=3D246133 How To Transfer Logins and =
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=3D298897 Mapping Logins & SIDs =
after a Restore
--=20
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.=20
Most experience comes from bad judgment.=20
- Anonymous
You can't help someone get up a hill without getting a little closer to =
the top yourself.
- H. Norman Schwarzkopf
[quoted text, click to view] "Charax" <chopkins@ameritech.net> wrote in message =
news:emVKDPt9GHA.3352@TK2MSFTNGP03.phx.gbl...
>I use an SQL Server 2000 database on my Windows XP Pro desktop. I have=20
> installed SQL Server 2005 on my laptop, also Windows XP Pro. Both are =
on my=20
> local MS Windows network workgroup at home. I use MS Access 2003 as =
the=20
> front end with ODBC.
>=20
> How do I copy (is that the proper term?) my 2000 database to the new =
2005=20
> installation on the laptop?
>=20
> Thanks in advance.
>=20
> Cheers,
>=20
> Charax=20
I use an SQL Server 2000 database on my Windows XP Pro desktop. I have
installed SQL Server 2005 on my laptop, also Windows XP Pro. Both are on my
local MS Windows network workgroup at home. I use MS Access 2003 as the
front end with ODBC.
How do I copy (is that the proper term?) my 2000 database to the new 2005
installation on the laptop?
Thanks in advance.
Cheers,
Charax
