#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    109
    Rep Power
    11

    Cool where to create a new DB with scripts


    Hellow, I'm new in MS SQL. in Oracle we can use sqlplus to run a script created elsewhere.

    Where and how can I run a sql script to create my database?

    Is there any ghrapfical tools to manage tables and to create triggers or indexes? what are the basic steps to enter and manage my tables.

    atferraz
  2. #2
  3. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,428
    Rep Power
    4539
    SQL Server includes many client tools for your server.

    Enterprise Manager, a graphical manager for sql server(s), DTS to transfer data in/out/between servers, Query Analyzer to run SQL directly (where you will run your sql script) are some. There are also profilers and other tools to help optimize your sql.

    You can use Access 2000+ as a graphical front end too. Access Data Project files are designed as a client/server front end for SQL Server. You can do nearly everything from an adp as you can in Enterprise Manager.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    109
    Rep Power
    11

    script in access project?


    Thanks Doug, my problem is that Iíve got the msde version and therefore, don't have those tools. My only option at the moment is access. Iíve already open the project, but where can I run the script in there?
    atferraz
  6. #4
  7. No Profile Picture
    Average Intelligence
    Devshed Novice (500 - 999 posts)

    Join Date
    Apr 2003
    Location
    Ohio/Chicago
    Posts
    678
    Rep Power
    12
    if all you have is access that's not really msSQL, but there's view options and you can select 'SQL view', there you can paste SQL code and run it.
  8. #5
  9. No Profile Picture
    Grumpier old Moderator
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2003
    Posts
    14,428
    Rep Power
    4539
    I usually use Query Analyzer for scripts. I don't know of a direct equivalent in an adp project. You can wrap your script in a quick stored procedure is one way.

    A google search turned up this which may help

    http://groups.google.com/groups?hl=e...3DN%26tab%3Dwg

IMN logo majestic logo threadwatch logo seochat tools logo