Database help

I uploaded the personal Start Kit on beta hodting but I could not transfer the aspnetdb to the server can any help me please.

 

Well they are no tables of aspnetdb on the database. I got only Album andPhoto tables. I need to know how upload aspnetdb tables and procedures for Personal Start kits.

 

You can use the aspnet_regsql tool to create a SQL script to generate the schema for the membership database (the aspnetdb). The syntax should look like:


aspnet_regsql -S mssql07.discountasp.net -U [your SQL login] -P [your SQL password] -sqlexportonly c:\name.sql -A all -d [your database name]

 

I did use the sintax that you provided before but it did not do any good.

 

Are you getting any error when you try to execute it using query analyzer? You will also need to make sure that you have update the web.config to use the new database as your membership provider.

 

Actually I did use query analyzer. I got http 500 internal server error (The page cannot be displayed) when I used open SQL file. However, It worked when I copy and paste sql text into qyery analyzer (only when I took off GOTO Cleanup line from sql file).</o>

 

I got this to work by visiting www.toadsoft.com &amp; importing using Toad.

 

Hi!

I now got anSQL Server 2000 database configured on DiscountASP. If I understand correct, I should be able to use Toad to export the database from my local SQL Express 2005to the server? I've got the connection to work all right from within toad and I've downloaded the script from Microsoft site, to add photo and albums tables. But I'm not sure as to how to get going from here. The database is named DB_155930_xxxx now.


If anyone could give me a hint on what to do now to get the personal website to work, I'dbe greatful.

Regards
Flemming