MSDE newbie quetsion: importing data from SQL Server

I've been given a file with no extension, and told that it's "a full
export from our SQL server tables".
What sort of file is this likely to be, and is there any way I can
import it into MSDE?
Simon Elliott http://www.ctsn.co.uk
hi Simon,
"Simon Elliott" <Simon at ctsn.co.uk> ha scritto nel messaggio
news:u5XG0NwQEHA.3728@.TK2MSFTNGP10.phx.gbl...
> I've been given a file with no extension, and told that it's "a full
> export from our SQL server tables".
> What sort of file is this likely to be, and is there any way I can
> import it into MSDE?
it really depend what kind of file it is...
it can be a full backup of a database, and you can test it executing from
any query tool
RESTORE HEADERONLY
FROM DISK = 'c:\....\filename'
which returns a result set indicating the content, if any and valid, of the
potential backup, or something like
Server: Msg 3242, Level 16, State 1, Line 1
The file on device 'd:\cursor.txt' is not a valid Microsoft Tape Format
backup set.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE HEADERONLY is terminating abnormally.
it can even be a DML sql file, containing a list of INSERT INTO statements
you have to execute to load an existing table... or a bulk copy export you
have to bulk insert..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||hi Simon,
"Simon Elliott" <Simon at ctsn.co.uk> ha scritto nel messaggio
news:%23ba4YhDREHA.3124@.TK2MSFTNGP12.phx.gbl...
> On 27/05/2004, Simon Elliott wrote:
> Is there a MSDE based on SQL Server 2000 available for free download?
>
yese, you can get the package at
http://www.microsoft.com/sql/msde/do...s/download.asp

> If so, how do I uninstall the current version? I've had no luck trying
> to uninstall it so far, as the uninstaller tells me that the service is
> still running, even if I have stopped it.
>
the uninstall applet shoul'd work as expected, but you can read
http://support.microsoft.com/default...oduct=sql&FR=1
for some hints on how to manually uninstall SQL Server 7.0 version...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||On 28/05/2004, Andrea Montanari wrote:
> yese, you can get the package at
> http://www.microsoft.com/sql/msde/do...s/download.asp
>
> the uninstall applet shoul'd work as expected, but you can read
> http://support.microsoft.com/default...276044&Product
> =sql&FR=1 for some hints on how to manually uninstall SQL Server 7.0
> version... --
OK, I'll give that a try. Thanks again for all your help.
Simon Elliott http://www.ctsn.co.uk