Sunday, March 25, 2012

exporting desktop MSDE to remote server Sql

What is the best tool for doing this? I have been using MSDE to create a
portal app on my desktop and now want to move the data from the MSDE db
locally to the remote server db. I can export the MSDE data but need a way
to get it to the remote sever and import it. Enterprise Manager seems to
be the tool of choice for this but I don't have it so I need another way.
Thanks!
Try WinSQL at http://www.synametrics.com/winsql. I have found to be the
best solution if Enterprise Manager is not available. It can move the
data as well as serve as a query tool.
Regards,
PM
Bob K. wrote:

> What is the best tool for doing this? I have been using MSDE to create a
> portal app on my desktop and now want to move the data from the MSDE db
> locally to the remote server db. I can export the MSDE data but need a way
> to get it to the remote sever and import it. Enterprise Manager seems to
> be the tool of choice for this but I don't have it so I need another way.
> Thanks!
>
|||hi Bob,
"Bob K." <bob1030@.hotmail.com> ha scritto nel messaggio
news:A2YLc.6720$eM2.877@.attbi_s51...
> What is the best tool for doing this? I have been using MSDE to create a
> portal app on my desktop and now want to move the data from the MSDE db
> locally to the remote server db. I can export the MSDE data but need a
way
> to get it to the remote sever and import it. Enterprise Manager seems
to
> be the tool of choice for this but I don't have it so I need another way.
you can have a look at Web Data Administrator,
http://www.microsoft.com/downloads/d...displaylang=en
which implements a Web interface where you can execute Transact-SQL scripts
and/or (partially) manage your databases...
other tools, both free and commercial can be found at
http://www.microsoft.com/sql/msde/partners/default.asp and
http://www.aspfaq.com/show.asp?id=2442 ..
you can have a look at a free prj of mine too, available at the link
following my sign..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

No comments:

Post a Comment