SQL: Publish to Shared hosting provider using the Database Publishing Wizard/SSIS/DTS

I am very happy with discountasp.net and have recommended to many.

Unfortunately the SQL hosting is lacking the ability to transfer data. It would be fantastic if discountasp.net offered the ability to
publish to a shared hosting provider using the Database Publishing Wizard (review section 8 onwards of the following url)

http://products.secureserver.net/products/hosting/PublishingWithDPW.htm

Alternatively, one of the following would be great

SQL Server Integration Services (SSIS)
Data Transformation Services (DTS)

I would like to know if discountasp.net are planning any of the above or offer any other service for data transfer.

Regards

Mark

 

Thanks Bruce,

I ideally wanted master slave sql replication to create a read only version of my data for my website.
I will testa scheduledcommand line version of the data publishing wizard and post my findings

Mark

 

I've had a look around to see if any other hosts offer the Database Publishing Service, looks like godaddy support it

http://help.godaddy.com/article/3435

 

I really, still, think it's much easier with SQL Server.
I've tested that tool and have done the exact same actions with the full version of SQL Server 2005 and the express version.
You have to use tricks in the express version but I still find it pretty easy.

Is it just for the Membership/Roles you want to use this?
Salute,
Mark

 

When you say "easier with SQL Server", i'm assuming DTS for 2000 and SSIS for 2005?

The company i am working for has an SQL 2000 based MIS system that maintains their products etc.
I am simply trying to create an online catalogue for phase 1 of the project.

I've been using the database publishing wizard (DPW) for the test environment butwillneed an automated approach for live.
I've reviewed the following and have come to the following conclusions

DTS - Test tomorrow(thanks for tip, research looking promising)
Command-line version ofDPW as a scheduled task- Depends on DASP support of Database Publishing Service
SQL Replication - Subscriber not supported by DASP
Or attempt to program something with web and windows servicessteep learning curve so last resort.

Or any thing else anyone can suggest.

Thanks for you help

Regards
Mark

 

There are so many versions of SQL Server being used right now this does tend to be confusing.
Depending on what is needed the actions are very different.
Yes DTS when possible is very handy.
For simple tasks I prefer two methods in the full versions of SQL Server:
1) The Import/Export tasks.
2) SQL windows. This was done with Query Analyzer in the past, before SQL Server 2005.

As an example of SQL tasks in any version of SQL Server look at some of the popular Forum packages.
Most of them use scripts to code the entire Database system, quickly, including any needed default records.
I don't like to use the SQL Express products but that is how they can do what the Data Publishing tool offers.

This is a good chat but please understand, there are volumes of books that are needed to describe these things.
All the best,
Mark

 

Thanks for your feedback

The only version of SQL that I'm interested in for this project is 2000 with the latest service packs.

The main requirement is thatthe process needs to be automated i.e. TheDASP database will need to be updated with data from my LAN every 2 hours, so, asking a user to manaully update the DASP SQL server is not an option.

I think testing DTS will be give me the answers i need

Regards
Mark

 

I fully agree with the DBA expert bro.

 

Hi Bruce
</o>
I am trying to configure the Database Publishing Wizard provider. I need to supply a secure Web Service Address for the provider to work.
</o>
I can?t find the address in my control panel, Can you provide this?
</o>
Regards
Mark

 

I think the following needs to be installed on my DASP server for the provider to work


http://www.microsoft.com/downloads/details.aspx?familyid=6F03273C-FFC8-4F5E-BAFC-041FBD68FD1E&amp;displaylang=en


Please confirm installation of Microsoft SQL Server Database Publishing Services 1.1 on DASP servers? if not, are there any plans to add this facility.
Regards
Mark

 

Thank you for explaining the differences/purposes of the database publishing wizard and DTS.</o>
</o>
I can now drop the DPW as an option and head down the DTS route</o>
</o>
Thanks to both of you for your help and please pass on my thanks to your DBA