How Do I Run Upsizing Scripts?

[JohnieR]

The .asp-based shopping cart sofware I'm using does not permit use of the Access 2000/SQL 2000 upsizing wizards but provides two scripts - convert.sql and sqlserver.bat. The first is said "to recreate the database. It can be used with ISQL or Query Analyzer to build the database". The second is said to be "a batch file that runs ISQL".

As a complete newbie to SQL 2000, I'm at a loss (the Admin Pocket Consultant isn't much help) to know how to run those scripts - or maybe I only need to use one of them. Guidance much appreciated.

 

[tlbroadbent]

Do you have database administrator? If so that person should run the convert script as it will likely be creating objects in SQL Server.

If you have Query Analyzer (QA) installed, you can load the script, convert.sql, and execute it.

These are the steps you would take if you don't have a DBA.

1) Start QA and connect to the SQL Server. Make sure you use a login that has all permissions necessary to create databases and other objects. Ideally, you can do this in a test environment rather than on a production SQL Server.
2) Open the script file using the standard Windows file open procedure.
3) If I were doing this, at this point I would analyze the script to make sure it won't damage my SQL installation in any way - a good reason to have a DBA.
4) Execute the script. And hope for the best.

You could run the BAT file. It probably contains one or more command lines to execute ISQL, which is the command line utility for executing SQL statements. The command line for ISQL should contain the security information for logging into your SQL Server. You or the DBA will need to validate that the security info is correct. If it is, then you can execute the BAT file from any PC that has ISQL installed and can connect to the SQL Server. ISQL will then execute the query script just QA would execute it. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.