How can I move a database?

Hi

I am having to move a database from one pc to another and would like to know
the best way to do so making sure that users and logins come across as well.

I am using MSDE 2000 Rel A and am moving it from a Windows 2000 pc to a
Windows XP Prof 2002 SP2 machine.

I have sucessfully installed MSDE on the new pc and can view it through
DBAMgr2k.

I need to know how to create the database and pull across all the
properties.

I tried generating an SQL script for all objects but when I tried to run it
on the XP machine (using DBAMgr2k) I received a "Count field incorrect or
syntax error" message.

Any help would be much appreciated.

Thanks

June


.

Relevant Pages

  • Re: How can I move a database?
    ... Since you are moving the system databases you will get the Logins, users, ... I am having to move a database from one pc to another and would like to ... Windows XP Prof 2002 SP2 machine. ... on the XP machine (using DBAMgr2k) I received a "Count field incorrect ...
    (microsoft.public.sqlserver.msde)
  • I cant even get Sharepoint Services Installed - Something about WSS_SEARCH_[MACHINENAME].
    ... I'm having a big problem installing Sharepoint Services 3.0 SP1 on a ... Windows 2003 SP2 machine. ... I also manually deleted the database files in c: ...
    (microsoft.public.sharepoint.windowsservices)
  • SourceForge.net Sitewide Update: Jan 26th, 2005 (fwd)
    ... I just returned from an enjoyable Open Source conference in Hawaii ... open sourced the database under the name Derby. ... The CVS client SF.net staff recommend for MS Windows users is ... priority technical support. ...
    (comp.os.linux.announce)
  • Re: Is this possible??
    ... I understand Windows security but since I've not seen A2007 live, ... The backend is on the server in it's own file. ... database, but everyone does not need to have access to tblwage which is ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How many companies are buying new AS400s
    ... Just like you do in iSeries navigator. ... SAVEPOINTs and ROLLBACKs are easy in any database that supports them, but what about analysis of the actual individual entries? ... Is it as easy to do this in Windows or Linux? ... I know how OS/400 work management lets me tune it so the customer is happy during those three or four minutes and is just as happy during the remaining 23:56 of the day. ...
    (comp.sys.ibm.as400.misc)