Standalone to SQL Server

  • Thread starter Thread starter Larry Waibel
  • Start date Start date
L

Larry Waibel

I'll be starting out with a standalone Component Database but I can see where
in the future we'd need to go to a SQL Server. How will I get all the
components/repositories/packages/etc moved from my standalone to the server?
 
Larry,

Would you like to elaborate what you mean by the "standalone Component Database"?

In any case you have a SQL server running. This would be either MSDE (free limited version of SQL Server) or full SQL Server
(Enterprise edition, or etc.).

For now you have probably installed only MSDE (goes with XPe ToolKit). If you want later on to move to SQL Server you would need to
stop MSDE service, copy database and repository (entire \Windows Embedded Data directory) to the server machine where you are going
to have SQL Server running, attach Mantis database there using Enterprise Manager tool of the SQL Server.
Then you launch CDM on client machine and change the network path to database to the server.

Also, read XPe SP2 documentation where it sass about Database Backup and Restore.
 
By 'standalone' I meant the MSDE running on my own local system. And you gave me just
the information I needed; thanks again!


From: "KM" <konstmor@nospam_yahoo.com>
Subject: Re: Standalone to SQL Server
Date: Wed, 26 Jan 2005 17:05:13 -0800
Newsgroups: microsoft.public.windowsxp.embedded

Larry,

Would you like to elaborate what you mean by the "standalone Component Database"?

In any case you have a SQL server running. This would be either MSDE (free limited
Click to expand...
version of SQL Server) or full SQL Server
(Enterprise edition, or etc.).

For now you have probably installed only MSDE (goes with XPe ToolKit). If you want
Click to expand...
later on to move to SQL Server you would need to
stop MSDE service, copy database and repository (entire \Windows Embedded Data
Click to expand...
directory) to the server machine where you are going
 
Back
Top