June 20, 2003 at 4:46 pm
Folks, before you answer my questions, please assume nothing about my level of intelligence.
I just want to simply upload my database to a Web Hosting service. I’d like to be able to see both databases local and on Web Host, and just copy and paste.
I’ve received some responses, but either they didn’t work for me, or I did not understand them completely.
I’m new to doing this, but can anyone walk me through some simple steps on uploading my local database from my PC (has tables and stored procedures) to my Web Hosting Service SQL Server.
I’m a unemployed home user with few $$$ to spend, but can consider purchasing a cheap utility if that’s what this takes, and I am open for suggestions on database management utilities.
Also, I already tried one utility that had a login screen, but when I tried to logged in to my local database, I kept getting “Not associated with a trust SQL Server.” Can someone also tell me on my PC (step by step) how I can become associated with a trusted SQL Server?
My local PC has installed:
MSDE 2000
Visual Studio .NET Professional Academic 2002 & 2003
Web Hosting Service has setup a Microsoft SQL Server database for me.
Thank you!!
June 21, 2003 at 9:22 am
Once you have figured out the connection issue (see my response to your other post), the easiest way for you to initially do this is with DTS. If you can make a connection, the DTS Import/Export routines can take care of most of this for you. I'm not currently at a system where I can bring up Enterprise Manager, but you might take a look in Books Online (the documentation that ships with SQL Server). If you don't have it, you can either use the version that's up on MSDN (http://msdn.microsoft.com/library/) or download it from here:
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply