Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740

    Unanswered: table setup tool (GUI or something)

    sorry if this is a dumb question. i've tried several searches here and on the net, but no joy.

    i'm comfortable with my Access/mySQL/innodb setup, but now i have a one-off project to move a back-end database to an existing MSSQL machine. i have not touched MSSQL life-to-date.

    admin will set up my instance, and then what?
    how do i get to create my tables and relationships etc...
    i hope it's not a bunch of CREATE TABLE command lines!

    for mySQL i use dbdesigner-4 which is a joy!
    is there some equivalent GUI for MSSQL table design? ...where?

    my prototype tables are currently in Access but they will certainly need modification for MSSQL use.

    thanks in advance for any pointers.

    izy
    currently using SS 2008R2

  2. #2
    Join Date
    Oct 2003
    Posts
    11

    Smile Creating tables in MSSQL

    Hi,
    In MSSQL you have Enterprise manager to help you create tables etc or use Query analyzer but then you have to write some "Create Table" statements.

    If you already have a database in MS Access you can export these tables to MSSQL thru an ODBC source.

    Set up a source to your MSSQL server/dB,
    right click on your table in MS Access and choose export on the table you like to export, then you need to choose odbc databases in "save as type:".

    Give it a try !

    Regards
    //T

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    In sql server there is a very user friendly GUI tool called
    Enterprise Manager (EM) where you can do all the operations you want to do
    on the database, but I personally prefer to use the Query analyser where you write the commands and create objects this way you have the complete hold on the process.

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    i still don't have access to the SQL machine - but from your comments it looks like i have all i need once i get on to the machine.

    thanks both.

    izy
    currently using SS 2008R2

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Perhaps you would be most comfortable creating an Access Data Project (.adp extension) linked to the SQL Server database. Then you can create tables, relationships, diagrams, procedures, etc in an environment very similar to MS Access, and with much of the development functionality of Enterprise Manager.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by blindman
    Perhaps you would be most comfortable creating an Access Data Project (.adp extension) linked to the SQL Server database. Then you can create tables, relationships, diagrams, procedures, etc in an environment very similar to MS Access, and with much of the development functionality of Enterprise Manager.
    Bimbo! Er, bingo! Yeah, what he said.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •