We are running MSDE on a Windows 200 server and it has data in it. What I
would like to know is can we also install MSSQL 2005 on that server and have
assess to both databases. Is there anything we have to do to install it and
make sure it doesn't overwrite or delete the MSDE database?
TIA,
Claytonhi Clayton,
Clayton Sutton wrote:
> Hey everyone,
> We are running MSDE on a Windows 200 server and it has data in it. What I
> would like to know is can we also install MSSQL 2005 on that
> server and have assess to both databases. Is there anything we have
> to do to install it and make sure it doesn't overwrite or delete the
> MSDE database?
MSDE and SQL Server 2005 can coexist on the same computer... just pay
attention, at installation time, not to "upgrade" the MSDE instance to a SQL
Server 2005 one..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||Yes this is possible, you just have to install it as a default or named
instance, which doesn=B4t equal the instance name of the MSDE, although
I doubt that this is possible through the installer to crash the system
that way. They are using different ports, so co-existence on the system
is possible.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Just interesting, why you do not want a run both databases on sql 2005?
Andris
Clayton Sutton wrote:
> Hey everyone,
> We are running MSDE on a Windows 200 server and it has data in it. What I
> would like to know is can we also install MSSQL 2005 on that server and ha
ve
> assess to both databases. Is there anything we have to do to install it a
nd
> make sure it doesn't overwrite or delete the MSDE database?
>
> TIA,
> Clayton
>|||An old app. that one dept. has been using for years was running on MSDE.
Now they are moving to a new program that uses MSSQL 2000/2005. However,
the old data is going to stay in the MSDE database (unless that dept. wants
to pay someone to do a data export/import into MSSQL). I just wanted to
make sure installing MSSQL on the same system as MSDE didn't wipe out MSDE
and all of the old data therein.
Clayton
"Andris" <spameris@.gmail.com> wrote in message
news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> Just interesting, why you do not want a run both databases on sql 2005?
> Andris
> Clayton Sutton wrote:|||I just migrated from MSSQL 7 to MSSQL 2005, whithout big headaches.
Simple backup/restore. With MSDE i think u can too, backup that db and
restore to MSSQL 2005. How i understand MSDE is some as MSSQL with some
restrictions on db size,replications etc. All who run un MSDE must run
un MSSQL. I have few msde servers who replicating with MSSQL, sometimes
i need open archive of these msde databases, i do this on MSSQL without
problems.
Sry my poor english
Andris
Clayton Sutton wrote:
> An old app. that one dept. has been using for years was running on MSDE.
> Now they are moving to a new program that uses MSSQL 2000/2005. However,
> the old data is going to stay in the MSDE database (unless that dept. want
s
> to pay someone to do a data export/import into MSSQL). I just wanted to
> make sure installing MSSQL on the same system as MSDE didn't wipe out MSDE
> and all of the old data therein.
>
> Clayton
>
> "Andris" <spameris@.gmail.com> wrote in message
> news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
>
>
>|||Hey Andris,
First thing, your english is fine. Don't ever apologize for that. Truth be
told, I can't spell
.Backing up MSDE is a little tricky. Most backup software doesn't have a
connector for MSDE so backing up and restore becomes a little harder.
The command line command to back one up is:
C:\MSSQL7\Binn>osql -Usa -P -n -Q "Backup Database dbname To Disk =
'c:\mssql7\backup\dbname.bak'"
It took me forever to find that command, and I don't know what the command
is to restore it.
Clayton
"Andris" <spameris@.gmail.com> wrote in message
news:%23sZUlTNdGHA.4108@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
>I just migrated from MSSQL 7 to MSSQL 2005, whithout big headaches. Simple
>backup/restore. With MSDE i think u can too, backup that db and restore to
>MSSQL 2005. How i understand MSDE is some as MSSQL with some restrictions
>on db size,replications etc. All who run un MSDE must run un MSSQL. I have
>few msde servers who replicating with MSSQL, sometimes i need open archive
>of these msde databases, i do this on MSSQL without problems.
> Sry my poor english
> Andris
> Clayton Sutton wrote:|||For the RESTORE syntax, you can see the SQL Server 2005 RESTORE syntax at
http://msdn2.microsoft.com/en-us/library/ms186858.aspx. For SQL Server 2000
(the MSDE info), you can download a copy of Books Online (BOL) at
http://www.microsoft.com/downloads/...DisplayLang=en.
Using the example syntax you provided, it would probably be something like:
osql -Usa -P -n -Q "RESTORE DATABASE dbname FROM
DISK='c:\mssql7\backup\dbname.bak'"
Note, however, that I haven't tested that. :-)
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Clayton Sutton" <none@.none.com> wrote in message
news:2mH8g.471159$7i1.118830@.fe06.news.easynews.com...
> Hey Andris,
> First thing, your english is fine. Don't ever apologize for that. Truth
> be told, I can't spell
.> Backing up MSDE is a little tricky. Most backup software doesn't have a
> connector for MSDE so backing up and restore becomes a little harder.
> The command line command to back one up is:
> C:\MSSQL7\Binn>osql -Usa -P -n -Q "Backup Database dbname To Disk =
> 'c:\mssql7\backup\dbname.bak'"
> It took me forever to find that command, and I don't know what the command
> is to restore it.
>
>
> Clayton
>
> "Andris" <spameris@.gmail.com> wrote in message
> news:%23sZUlTNdGHA.4108@.TK2MSFTNGP03.phx.gbl...
>|||Hey Steve,
Would that restore the DB to MSDE only. What if you wanted to restore it
into MSSQL 2000 or 2005? That's really what we are talking about, how to
move from MSDE to MSSQL 2000/2005. Get the data out of MSDE and into MSSQL.
Clayton
"Steve Dybing [MSFT]" <steve.dybing@.online.microsoft.com> wrote in messa
ge
news:uIP9O6QdGHA.1436@.TK2MSFTNGP05.phx.gbl...
> For the RESTORE syntax, you can see the SQL Server 2005 RESTORE syntax at
> http://msdn2.microsoft.com/en-us/library/ms186858.aspx. For SQL Server
> 2000 (the MSDE info), you can download a copy of Books Online (BOL) at
> http://www.microsoft.com/downloads/...DisplayLang=en.
> Using the example syntax you provided, it would probably be something
> like:
> osql -Usa -P -n -Q "RESTORE DATABASE dbname FROM
> DISK='c:\mssql7\backup\dbname.bak'"
> Note, however, that I haven't tested that. :-)
> --
> Sincerely,
> Steve Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Clayton Sutton" <none@.none.com> wrote in message
> news:2mH8g.471159$7i1.118830@.fe06.news.easynews.com...
>|||MSDE is SQL Server. So you can both attach and restore an MSDE 2000 database
into SQL Server 2000 or
2005.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Clayton" <none@.none.com> wrote in message news:8GV8g.100380$JV1.10779@.fe05.news.easynews.co
m...
> Hey Steve,
> Would that restore the DB to MSDE only. What if you wanted to restore it
into MSSQL 2000 or 2005?
> That's really what we are talking about, how to move from MSDE to MSSQL 20
00/2005. Get the data
> out of MSDE and into MSSQL.
>
> Clayton
>
> "Steve Dybing [MSFT]" <steve.dybing@.online.microsoft.com> wrote in mes
sage
> news:uIP9O6QdGHA.1436@.TK2MSFTNGP05.phx.gbl...
>
No comments:
Post a Comment