How do I get database?
I want to remove my database from the server it currently resides on. How do I do this without having the proper software? (i.e. Visual Studio)..or anything else like that? The database is on an MS SQL Server and has about 50,000 records. I tried downloading it through Microsoft Frontpage but that doesnt seem to work.
Thanks,
Ravi
Peter J. Boettcher posted this at 18:40 — 21st November 2000.
They have: 812 posts
Joined: Feb 2000
Ravi,
You didn't say if you wanted to keep the data or not. If you simply want to delete it just make an ASP page and use the DROP TABLE [tablename] command. This will remove the table.
If you want to keep the data then you'll have to export it to another database. You could upload an empty Access database that has all the same table & field names and then create an ASP page that selects the data from the SQL database and then inserts it into the access database, you could then download the Access database.
The simplest way would be to use Enterprise Manager and use the built in tools and wizards rather than creating ASP pages. If you don't have it then go to Microsoft's SQL site (www.microsoft.com/sql) and order the evaluation version which is only $9.95) this comes with Enterprise Manager. You don't have to install SQL server, just select Desktop installation and then select connectivity tools.
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.