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

Exporting Data from excel to SQL Server express

Hi

I have managed to add the DTS wizard as a tool and saved the routine. However, I do not know how to schedule my PC to automatically run this DTS procedure. I have tried to use scheduled tasks, but it does not seem to want to start.

Pls help.

It was absolutely amazing.

Just by typing in "SQL Server" and Excel in the search box on this page in the forums, I found these previous posting on the same topic...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1083746&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295895&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=970723&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=304674&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=985930&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1083317&SiteID=1

There were more...

|||

Hi Arnie,

Thanks for the suggestion, I discovered a a previous post you made. You suggested that you get scheduled tasks to run dtsrun.exe. I do not have DTSrun.exe and surely you would have to make the executable run only your specified saved DTS 'routines'. How would you do this?

Regards

George

|||

Perhaps these will help guide you.

DTS - How to Run a DTS Package as a Scheduled Job
http://www.support.microsoft.com/?id=269074

DTSWizard.exe
http://go.microsoft.com/fwlink/?LinkId=65111

|||

Hi

Thank you for your help, but unfortunately the above solutions do not seem to work. Let me explain my situation more completely:

I have installed Microsoft SQL Server Express Edition with Advanced Services SP2 and the Toolkit. I have made the DTSWizard a tool in SQL management studio express I have transferred sample data into the database using the DTS tool. I have 'saved' the DTS transfer|||

For command line details about executing a 'package', refer to Books Online, Topic: dtutil

export resultsets in ms access

I have a sp which return mutiple result set.
Is there any way by which i can export the multiple resultset data in ms
access using some tool, DTS etc.ADO in VBA supports the NextRecordset method for doing this and it is
possible in MSAccess. Check the help for NextRecordset.
Hope that helps.
Let me know how you get on.
Damien
"Vikram" wrote:

> I have a sp which return mutiple result set.
> Is there any way by which i can export the multiple resultset data in ms
> access using some tool, DTS etc.
>
>