Change location of an Existing DB in MSDE

Hi everyone,
I have an MSDE database that was created using the osql.exe. By default it gets automatically created in the MSSQL7/data directory.
Does anyone know how i can detach and then re-attach the database from a new location?Refer to SP_ATTACH_DB & SP_DETACH_DB topics in books online.

Also you can mention path for data files while using CREATE DATABASE Statement.|||Have U thought of

1)Backup db
2)copy the mdf & ldf files
3)delete the db
4)create a new db with same name but data files in the new place
5)overwite the new files (s'be same name) with the original files
(Don't know if u have to stop the SQL Service to do this bit)

or do 1) 3) & 4) + restore db

Worth a try

Ye Hah !

GW

CE upgrade tool?

Have anyone written a tool to upgrade from CE to Everywhere that is easier to use that the upgrade.exe program?

Thanks

Hi,
I have written a free GUI Interface to it - available at
http://www.gui-innovations.com/download/SqlUpgrade.zip

Pete

|||

Hello Pete,

Thanks for the link to your program.

I ran the program and got this error message:

SQLMobile appears not to be installed - can't continue. Cab files should be in the C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0 folders on your PC

What product/SDK is it expecting?

Thanks

Tom

|||

Hi,

you will need the .Net CF 2 runtimes, and the SqlMobile runtimes on the PPC to run it

Pete

CD Install

I would like to extract the self extracting exe files to go to a directory so I can burn a CD. I have tried burning the CD's from the temp directory but it wouldn't install properly from the CD. Is there a command line parameter to get around this? TIA

Add "/x" (no quotes) to any of the express packages (e.g. SQLEXPR.EXE /x) and you will be prompted for a directory to extract the files to.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.