November 23, 2010 at 4:18 am
I need to export a database from a hosted server to our own systems.
I have only access to the webserver, that uses the database, not to the database(server) itself.
So I need a vbscript/asp I can put on the webserver to make a create-script for making the data
and the data in either csv's or a sql-file with inserts.
Or ideally a "slave-script" on the webserver, which a script on our server can query for structure, then create the tables locally,
then for each table request a suitable number of records from the slave, and insert into the local database.
November 23, 2010 at 5:06 am
Can you use PowerShell instead? If so, I've got a good script I can point you to.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 23, 2010 at 5:14 am
I can only ftp an asp-script to the server, and open it in a browser.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply