How do I tranfer my db to discountasp.net

[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,

[bruce]

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.



[b]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">

[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...

[bruce]

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.



[b]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">

[bruce]

I found it..

http://www.aspenterprisemanager.com/

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


[b]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">

[Mark Jerde]

The eval edition of SQL Server 2000 is available from this page.
http://www.microsoft.com/servers/evaluation/trial/default.asp

Which tool does one use to move tables from my local machine to discountasp's? I'm connected with both Enterprise Manager and Query Analyizer. I've used MS Access for years but this is my first real experience with SQL Server. [:)]

BTW, other low-cost tools are available here.
http://www.msde.biz

Thanks.

-- Mark

[Mark Jerde]

[b]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

[bruce]

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


[b]quote:Originally posted by Mark Jerde

[b]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">