Board index MS SQL Server

Scripting question for SQL-Server 7

Scripting question for SQL-Server 7

Post by Bo Berglu » Fri, 21 Jan 2000 04:00:00



I have created a script for all objects in a selected database in
Enterprise Manager. This has resulted in a 450k+ sql file in unicode.
Now I want to use this script file to create a duplicate of the
original database in another server. In this case I know how to do
that from Enterprise Manager but I would rather do it from a remote
login.
Is this at all possible and what kind of commands are available?

I have looked for a suitable stored procedure but found none. It would
be nice to have something like:


which could be executed from a remote location still using the script
file on the local server disk. I could copy it there over the network
before I issue the SQL-Server command.

TIA

Bo Berglund
Software developer in Sweden

PGP: My public key is available at the following locations:
Idap://certserver.pgp.com
http://pgpkeys.mit.edu:11371

 
 
 
Top

Scripting question for SQL-Server 7

Post by Kevin Connel » Fri, 21 Jan 2000 04:00:00


This is a bit of a kluge, but how about scheduling an CMD/BAT file that
has the correct command line to run ISQL and run your script?

> I have created a script for all objects in a selected database in
> Enterprise Manager. This has resulted in a 450k+ sql file in unicode.
> Now I want to use this script file to create a duplicate of the
> original database in another server. In this case I know how to do
> that from Enterprise Manager but I would rather do it from a remote
> login.
> Is this at all possible and what kind of commands are available?

> I have looked for a suitable stored procedure but found none. It would
> be nice to have something like:


> which could be executed from a remote location still using the script
> file on the local server disk. I could copy it there over the network
> before I issue the SQL-Server command.

> TIA

> Bo Berglund
> Software developer in Sweden

> PGP: My public key is available at the following locations:
> Idap://certserver.pgp.com
> http://pgpkeys.mit.edu:11371


 
 
 
Top

1. Question about generating script in SQL Server

Hi. In enterprise manager (SQL Server 2000), "Generate the DROP <object>
command for each object" is selected by default when you generate the
SQL script. I would like to ask if there is a way to set it not selected
by default as this causes any existing objects in the database to be
deleted first, when it is executed.

Thank you

VincentWong

2. Win95 ODBC 2.5 driver?

3. Converting Oracle-Scripts to MS-SQL-Server-Scripts

4. SQL RDO DSN-less problem

5. Running on SQL Server 2000 Script prepared for SQL Server 6.5

6. SQL, Help Me Please

7. Converting SQL Server 7.0 Scripts to SQL Server 6.5

8. Using Pivot Tables with OLAP

9. Server script to run script in database (FMP Server 5)

10. Script question: SQL & PL/SQL variables

11. Scripting Replication for move to another server (sql server 7.0)

12. (very)Newbie Script/Sub-script how to question


All times are UTC
Board index