How do I tranfer my db to discountasp.net

Couple ways you can do that

1) Download or get the trial copy of MS SQL 2000 and just install the SQL Clients tool (client tools do not expire). This will install Enterprise manager and query analyser

2) If you are using VS.net, you can also use the server explorer to connect to the DB. (i think this is a tone downed version of the enterprise manager). This tool allows you to manage the database but I do not know of a way to move data using this though.



quote:Originally posted by john

I used VS.NET and MSDE to develop my site. Since I don't have SQL Server Enterprise Manager or Query Analyzer, how do I upload my stuff unto my space at discountASP.NET?

thanks,
</blockquote id="quote"></font id="quote">

 

Oops...

Bad news. MS seems to have taken the eval download offline

http://www.microsoft.com/sql/evaluation/trial

I have seen a few tools before, i'll post it when i find the link.



quote:Originally posted by john

1) Hmmm. I don't have a version off hand, otherwise I would have tried that. Microsoft seems to hide all their downloads in layers of links... If you this out of the top of your head, please feel free to help, thanks.

2) To generate create scripts from Server Explorer, I need SQL Client Tools. MS is not being intuitive sometimes. If I have SQL Enterprise Manager, why would I use client tools?

I will post my solution once I figured it out...
</blockquote id="quote"></font id="quote">

 

I found it..

http://www.aspenterprisemanager.com/

it's an asp.net based enterprise manager (freeware). I have not try it personally though.


quote:Originally posted by john

1) Hmmm. I don't have a version off hand, otherwise I would have tried that. Microsoft seems to hide all their downloads in layers of links... If you this out of the top of your head, please feel free to help, thanks.

2) To generate create scripts from Server Explorer, I need SQL Client Tools. MS is not being intuitive sometimes. If I have SQL Enterprise Manager, why would I use client tools?

I will post my solution once I figured it out...
</blockquote id="quote"></font id="quote">

 

Thank god, MSFT finally made the eval SQL server available again. it was offline for a long time since the SQL slammer hit.


quote:Originally posted by Mark Jerde

quote:Originally posted by Mark Jerde

Which tool does one use to move tables from my local machine to discountasp's?
</blockquote id="quote"></font id="quote">

Ah! Enterprise Manager's Data Transform Services.

-- Mark
</blockquote id="quote"></font id="quote">