MSDE --> 3rd Party server -- sql server dts

Allan Mitchell
1/7/2004 3:12:46 PM

BACKUP/RESTORE will do it quite nicely

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]

Allan Mitchell
1/7/2004 5:16:41 PM

So you can BACKUP your local instance of MSDE
You cannot RESTORE to your ISP

Correct?

Will they not do that for you ?

http://support.microsoft.com/?kbid=207809

If you are using SQL Server 7 then the above will affect you and seeing as I
doubt you will be able to convince them to change the licencing mode it
could be difficult to use DTS here.

I do not move data between MSDE and "Big" SQL Server so am unsure if this
restriction is still in place in 2000.

What version are you running/they running?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]

Darren Green
1/7/2004 8:14:38 PM

In message <096101c3d521$2f964480$a501280a@phx.gbl>, Paul Shaddick
<anonymous@discussions.microsoft.com> writes
[quoted text, click to view]

The simplest method would be to use SQL scripts to create the objects
and insert any data you require. Using scripts is also one of the best
methods for release and change management.

DTS would be useful to transfer the data on an ongoing basis. MSDE
normally ships with Dts, which you can can use via the object model, but
building packages would be a lot simpler with a copy of Enterprise
Manager. For this you could use a copy of SQL Server Developer Edition,
and at 49 USD or about the same in most other currencies, I don't think
it is too expensive even for low cost outfits, especially when you
consider the time it could you during development.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Paul Shaddick
1/8/2004 8:11:11 AM

Thanks Allan I appreciate your thoughts.

Answers/comments inserted below

[quoted text, click to view]

Yes, I can even BACKUP the hosted database, but do not
have the exclusive rights necessary to restore to it.

[quoted text, click to view]
Yes they would probably do a restore for me - after a
while by special request. However the hosting package
only includes a single database so I am using it for
intranet content management as well. So I could really do
with the selective copy/move capabilities of DTS.

I have the Enterprise Manager tools through a trial
download version of SQL server - The engine expires but
the tools don't.

[quoted text, click to view]
Yes the hosting company are running SQL Server 7 and the
knowledge base article describes my problem. They say
they are planning to upgrade 'soon' but I have no idea if
the restriction will still be in place.

[quoted text, click to view]

Paul Shaddick
1/8/2004 8:31:52 AM

Thanks Darren,

I must say moving to using SQL Server technology rather
than Access databases is certainly a steep learing curve,
especially when trying to get by without paying a fortune
for the full set of tools. Microsoft encourage the little
people like me in this direction by giving away MSDE and
it's only when we get half way up the mountain that we
realise that it shouldn't be done without major
investment in mountaineering equipment!

I think I can auto-generate the SQL scripts to build the
data structures, but my SQL isn't really up to doing much
in the way of moving the 'fixed' data required by the
application. Or are DTS packages basically SQL scripts
which I could copy text from and run manually?

I currently use DTS and Enterprise Manager through a
trial download of SQL server - the tools don't seem to
expire.

I'd be happy to buy a copy of the Developer Edition if I
was sure it would enable me to use DTS on the hosted
database. I would also feel more comfortable that my copy
of Enterprise Manager was legitimate. Can anyone confirm
that this would solve my problem?

Allan Mitchell
1/9/2004 6:46:41 AM

Seeing as the "Licencing" issue affects you I am not sure that you are going
to be able to work through this with DTS for the reasons mentioned.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]

Darren Green
1/12/2004 9:24:18 PM

In message <07bc01c3d604$ec052800$a001280a@phx.gbl>, Paul Shaddick
<anonymous@discussions.microsoft.com> writes
[quoted text, click to view]
There are plenty of free tools around or even scripts that will generate
insert statements from existing table data.

e.g.

http://www.rac4sql.net/qalite_main.asp

[quoted text, click to view]
I'm sure that is in violation of the eval agreement.

[quoted text, click to view]
I assume that buying developer allows you to develop locally and then
use Dts to deploy data to the hosting server. For an accurate answer
contact your local MS Office and ask for the licensing dept.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : MSDE --> 3rd Party server