Forgive such a fundamental query from an SQL newbie but I'm really stuck. The third party, ASP-based cart software I'm implementing draws on a 27-table database. Upsizing using the Access 2000 wizard is not permitted, say the cart authors, because of its particular construction. Instead, one is provided with two special scripts. The docs say only this:
"sqlservershopping.sql is designed to recreate the database. It can be used with MS ISQL or the Query Analyser utility.
sqlservershopping.bat is a batch file that runs ISQL."
I've installed MSDE - the desktop equivalent, supposedly, to SQL Server - in the hope of performing that operation locally. The server runs but I'm darned if I know what to do next. The references to ISQL and Query Analyser put me in a fog. Not even sure whether they relate to SQL Server or to Queries/SQL Specific within Access itself.
I have full access to the remote server that will host the site but am equally ignorant of how to run the scripts to create an upsized version there. There are references on the MS site to Enterprise Manager to run Query Analyser but I can't find my way into that either. Any help very gratefully received.
"sqlservershopping.sql is designed to recreate the database. It can be used with MS ISQL or the Query Analyser utility.
sqlservershopping.bat is a batch file that runs ISQL."
I've installed MSDE - the desktop equivalent, supposedly, to SQL Server - in the hope of performing that operation locally. The server runs but I'm darned if I know what to do next. The references to ISQL and Query Analyser put me in a fog. Not even sure whether they relate to SQL Server or to Queries/SQL Specific within Access itself.
I have full access to the remote server that will host the site but am equally ignorant of how to run the scripts to create an upsized version there. There are references on the MS site to Enterprise Manager to run Query Analyser but I can't find my way into that either. Any help very gratefully received.
