Post reply

Need to show my functions of SQL server in a diagram

  • July 22, 2011 at 1:01 pm

    #244555

    Hello,

    I just need a big help here, I have to carry a presentation for my SQL server,

    I want to put the functions in a diagram,

    Functions of SQL, it is 200R@ with 3 datbases,

    Talks to scanners as our is courier company,

    There are some windows djobs which moves the data from AS400 to and from the scanners,

    Please Help

    Dev

  • July 22, 2011 at 1:20 pm

    #1357270

    dsohal (7/22/2011)

    Hello,

    I just need a big help here, I have to carry a presentation for my SQL server,

    I want to put the functions in a diagram,

    Functions of SQL, it is 200R@ with 3 datbases,

    Talks to scanners as our is courier company,

    There are some windows djobs which moves the data from AS400 to and from the scanners,

    Please Help

    Dev

    If your asking for someone to create the diagram and presentation then you are going to need to provide additional information.

    You could use something like Visio to map out the process.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 22, 2011 at 10:10 pm

    #1357376

    Hello, yes I would highly appreciate if someone can get me the diagram made for me,

    we have one Sql server in our network, then we have AS400, one server where windows jobs run,

    This is scenerio,

    scanning is done using scanners in warehouse and the data moves to AS400, then manifest are printed of AS400 and there is job runs on windows job server which moves the data to one database in SQL server,

    then there runs windows job in sql server which moves the data to 2nd sql database which is the the portal database, all the pins loaded to the dashboard,

    then driver get there data transfered to there driver scanners in wifi mode, once the drivers go out on road they get on to cell connection, they communicate to sql server via cell as there is rule for sql server in our DMZ

    then the data get transfered to TAP in reverse order,

    I would appreciate if someone can get me the diagram,

    Thanks in Advance

  • July 23, 2011 at 8:22 am

    #1357424

    Do you have Visio?

    Give a man a fish and he will eat for a day. Teach a man to fish and he will eat for a lifetime.

    Confucius, K'ung Fu-tzu, K'ung-tzu, Kong Zi, Kong Qiu, Zhong Ni

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • July 23, 2011 at 8:38 am

    #1357427

    No I do not

  • July 23, 2011 at 8:42 am

    #1357428

    You will need something like Visio so that you can create, maintain and print your diagram(s) as needed.

    You may download Visio 2010 from the following site:

    http://office.microsoft.com/en-us/visio/

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply