Database Documentor Tool?
Sep 21, 2007Hi everyone!
Does anyone have any database documentor tool to upload?
I need to create a report of tables (with columns) for my database (sql server).
Thanks in advance!
ADVERTISEMENT
Table Documentor
Oct 20, 2005I am sort of new to SQL. I use MS-Access most of the time so I do not knowif you can do this, but...In MS-Access there was a tool called documenter that would list out thetable def's such as fields, sizes, data types, etc. Is there such a thing inSQL?I am using MS-SQL 2000 server.Mikem charney at dunlap hospital dot org
View 3 Replies View RelatedSQL Database Administration Tool
Jun 26, 2005Hi...
Does anybody know of an open source script I can download that will enable me to manage an SQL database? I basically need to access and modify the database from any machine that may not have SQL Enterprise Manager Installed. I was thinking of writing my own script to do this but I assumed that there is probably already one out there.
Database Comparison Tool
Feb 2, 2001I am looking for a database comparison tool/utitlity that does db comparisons, generates reports and has the provision to do the updates.
View 2 Replies View RelatedDatabase Management Tool
May 24, 2005Hi All,
I installed sql server 2005 express edition beta 2. which come as part of visual studio 2005 beta 2.
Please tell me which administration tool i have to use to manage my database.
Thanks
mk_garg
Database Design Tool
Feb 5, 2008Hi Guys,
I am not sure this is the right section to post this in, but ModelRight (www.modelright.com) is releasing a new version of its database design tool that supports SQS 2005/2008. I think the tool provides many advantages over the existing tools (deep SQS support, excellent UI, easy to use, etc).
Currently ModelRight is looking for SQS beta testers. If you want to participate just please go to the website and download the latest version.
Thanks.
Does Anyone Know Of A Tool That Allows A SQL Server Database To Be
Jul 3, 2006Does anyone know of a web based tool that allows a SQL Server databaseto beadminstered from the Internet? (in php)
View 2 Replies View RelatedDatabase Diagrams Tool
Jun 26, 2006When I use the sql 2005 "Database Diagrams" tool for the first time I always get the message: "The Database does not have one or more of the support objects required to use database diagramming. Do you wish to create them?"
1. Does anyone know what the " support objects" referred to are?
2. Why SQL doesn't automatically create these support objects for me? (e.g. do they require a lot of hard disk space so they shouldn't routinely be created?)
3. Is there any way to make Sql automatically create them?
If you can address any of these points I'd appreciate it.
TIA,
barkingdog
Cannot Connect To Sql Database Using Config App Tool.
Oct 15, 2007hi All
I'm new comer , the first time to work with Ent lib , I try to use modify sql connection string using configuration application tool integrated in Visual Studio against sql server 200 , I got this error . _http://imagesshared.com/images/jdv1192388741v.JPG I don't know how to solve my problem , someone please help me to overcome this problem .
Thanks in advance .
sorry for my poor English , I'm a Vietnamese student .
MSSQL Database Comparison Tool
May 25, 2005Does anyone know of a good (free) tool that will compare the structure of two databases. Something that will compare Stored Procedures and Views would be great.Thanks.
View 3 Replies View RelatedSql Server Database Comparison Tool
Oct 6, 2005Hi, I'm looking for a tool to compare 2 sql server database and makes a script of the differences (like an added table or record). We want to use it to generate a script which we can send to our customers to update their database if a change has been made. Example: We send our customers database A. After half a a year they request some changes to be made to the application that affects the database, say a table has to be added. We want the tool to automatically detect the difference between database A when it was first released and after the changes has been made and generate a script. Anyone suggestions? T.I.A., ratjetoes.
View 1 Replies View RelatedDatabase Reporting Tool Needed
Apr 20, 2006Hi,
I need software that will write a report on the following items that I can have prepared to show our auditors. Any suggestions ??? OUr databases are SQL*Server 2000, SP 3a / SP4
1) database consistency checking
2) re-indexing
3) shrinking
4) allocation of growth boundaries
5) backup routines
6) disk space
7) table space
8) processing speed
Thanks so much,
Nancy
What Tool To View SSCE Database?
Mar 11, 2008
What tool should I use to view SQL Server Compact Edition database?
I have VS2008 Professional, but I didn't find any tool in the installation. So I tried to install the SQL Server Developer Edition, which is included in the VS2008 package, but the installation has quit saying the that there is nothing to upgrade (there is probably newer version of SQL installed by VS2008 itself).
I also tried to download and install SQL Server Managment Studio Express. The installation went well, but then I wasn't able to select any SSCE database (there was only SQL Server Express or something like that selectable).
Is there anything else I should do?
Tool To Create Small Database With MSDE
May 12, 2004Hi,
I'm a newbie with SQL so excuse my igorance. I'm running an application that uses MSDE2000 as its source db and would like to create a small [10 field] db that would also use MSDE. I want to use a separate db though and not share the first one. What I'm looking for is suggestions on a development tool to create the database with as I'm not familiar with SQL tools. I have a lot of Access experience though so the concepts are not new.
Database requirements are pretty basic.
10 fields [8 text, 2 numeric]
A button field to Add New Record
A search field
Column sorting.
That's it. I could do this in a pinch with Access so knowing what tool to use should make it easy. Any chance that I could do it with Access and then port it to a SQL db?
Thanks,
Bob
Is There A Tool For Creating Database Schemas From SQL 2000?
Sep 30, 2005Be gentle, I'm new! :o
We have three databases running on SQL 2000 and would like a visual database schema. We'd rather not do it by hand. ;)
The free-er, the better!
Thanks in advance
Rajendrakumar Varsani
Need Tool For Managing Database Object Ownership
Jun 26, 2006we have a group of developers which have created and asked us (DBAs) tocreate many objects in the databases including tables / storedprocedures / functions / etc.since our company is growing, however we have an increasing amount ofobjects that have either been abandoned or have several versions.in an effort to clean of the huge amount of clutter and anytime thatsomething simple like a stored proc needs to change, it is almostimpossible to predict exactly where we will see negative effects ofthis change.i am looking for a system (preferably without developing our own tool)that would keep track of history of database objects (in terms of whocreated it and what purpose it has) as well as link that to all thedevelopers/users we might need to notify of any changes to that object.Also, this should be linked to the application which rely on theobject.bottom line... every object in the database needs to have at least 1corresponding contact as well as the applications which us it.with this information, we can much more easily maintain objects in ourDBs.thx
View 3 Replies View RelatedTool That Create Sql Script To Recreate A Database
Jul 20, 2005I need a tool that creates a script to recreate a db, including tables' data.Does it exists freeware ?thanks!
View 2 Replies View RelatedWhat Is A Good Tool For Modeling A SQL Server 2005 Database?
Nov 20, 2006Hello,
I need a tool that will let me model a SQL Server 2005 database and then generate the tables, constraints, etc. from the model. I've never used a modeling tool so my knowledge is quite limited. I don't need to model or reverse engineer an application - my sole concern is on the SQL Server database side. I'm not concerned if the tool integrates with Visual Studio. And, of course, price is one consideration.
Are there any good tools that I should look at?
Thanks,
BCB
Web Administrator Tool - Unable To Connect To SQL Server Database.
Apr 30, 2008I would like to setup the membership and role in web administrator tool, however, under Security section, I got the error message of "Unable to connect to SQL database".
I tried to run aspnet_regsql.exe to edit the config(C:WINDOWSMicrosoft.NETFrameworkv2.0.50727>aspnet_regsql.exe), however, it still shows this error message.
I am using web developer 2008 and SQL Server 2005.
Please advice me how to tackle this problem.
Thank you.
Beta Testing A Cross Database Integrity Tool
Nov 21, 2006Hi,
We are in search of beta testers for our new software tool for SQL Server : Remote Keys allows you to define and enforce cross databases integrity constraint. With Remote Keys, you can create a foreign key between to SQL tables located in distinct databases.
Beta version can be downloaded here : www.remote-keys.com.
Thank you,
Tom
Beta Testing A Cross Database Integrity Tool
Jan 5, 2007Hi,
We are in search of beta testers for our new software tool for SQL Server :
Remote Keys allows you to define and enforce cross databases integrity
constraint. With Remote Keys, you can create a foreign key between to SQL
tables located in distinct databases.
New version (beta 2) can be downloaded here : http://www.remote-keys.com
Thank you,
Tom
Asp.net Confgiguration Tool. Tool Keeps Timing Out
Mar 2, 2006is it possible to change the settings on this tool. i want to have it so that it does not time out at all? or is that possible??
View 1 Replies View RelatedSQL Server Express Is Working - What Tool Do I Use To Create Database And Tables?
Aug 16, 2006Hello,
I have SQL Server Express working however I don't see any tools to create a database and tables.
I am trying to create a database to store stock quotes that I will input from a c# program.
What tool should I use to design the database?
Thank you!
Toben
Setting Up Sharepoint Asset Inventory Tool On Windows Internal Database Server
Apr 4, 2008I have a sharepoint on a windows internal database server (some version of sql express 2005). When I run the app, it says that I need SQL server reporting services 2005. I dont think that this component is bundled with "windows internal database server". Is there anyway I can download this component or otherwise make this work?
Seems a bit silly that they would make a tool requiring a component that doesnt need to be installed for sharepoint to run.
Looking For A Tool/ Middleware Tool Which...
Jul 23, 2005Hi all.I'm looking for a tool which should act like some kind of middleware/logical layer bewtween the SQL server and the webbased user interface.- It should be possible to easily create simple web forms (only datainput and output) without programming effort by "clicking" the fieldsand their order on the web mask within an admnistrative interface.- It should also be bossible to add "new fields" to the database,including field type, permissions, value lists etc. (excluding anybusiness logic) without programming effort by administration.I know, that most workflow tools or "Trouble Ticket Tools", based ondatabases have this feature to easily configure new masks and add newfields to the database, but i need it as an tool-unspecific layer forthe MS SQL Server.Thank you very much for your feedback, any ideas are welcome!Best regards, Heiko.
View 1 Replies View RelatedData Scripting Tool ( NOT DATABASE Scripting)
Mar 16, 2004Hi to all
Is there any option in sql server DTS or any other third party tool that can script data. By scripting data i mean that....
if a table "Employee" contains 50 rows, i want the tool to write 50 insert queries for me so that i can run in it anywhere.
Problem is i have to insert data in a remote server where i cannot use DTS. I just have a text area to write my query and press the run button..
Hope u understand my problem. In case of any explanation please reply. Waiting for your response. Thanx in advance.
by to all
Can Anyone Help Me Regarding Tool
Jul 22, 2005hiis there any tool to write stored procedurei have long queries to write instead of that i want a tool or editor where i can click or drag and drop to write procedurei make my work to complete fasterif any please tell me the site to downloadthanx byeramesh
View 1 Replies View RelatedSQL Tool
Aug 5, 2005Hello,I'm looking for recommendations for SQL tools used for comparing schemas from different databases. I would like the tool to be able to compare schemas for at least two databases and list the difference in tables, sps, functions, and view. Even if the both schemas contain the same structures I would like to know what differences exist. Also, I would like to be able to type in a table field name and get a list of every place in the db that field is referenced. On another note, how do others go about maintaining a version history of db structures? Any tools available for this functionality? Currently, I use visual source safe for my app. code. I could place copies of my SPs in visual source safe and edit them within visual studio. I'm not sure how I would easily get the edited version into my sql database without having to create a script or copy the edited version back to the db. Any thoughts?Any information is appreciated.Oscar
View 1 Replies View RelatedSql Bcp Tool.
Apr 23, 2008Hi guys, Im trying to use Bulk copy to transform a csv file into a table
BULK INSERT [BULK_INSERT_TEST]
FROM 'c:stock.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = 'N'
)
--*STOCK LOOKS LIKE THIS
stockcode,barcode,qty
10002,"10002087",0
TABLE Looks like this
id, stock,barcode, qty
can anyone give any guidance on performing this - at present this doesn't seem to work. Worth mentioning id is autoincrementing. I would also need to strip quotes around the second field. Note. Stock file has a header - do I need to strip this to use BCP?
Any help appreciated.
2,10002,"10002087",0
SQL Bcp Tool
Oct 18, 2007Hi,
I am using bcp to copy some data from a flat file to a data table using the format file that look like this.
9.0
7
1 SQLCHAR 0 4 "" 1 Col1 SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 0 9 "" 2 Col2 SQL_Latin1_General_CP1_CI_AS
3 SQLCHAR 0 8 "" 3 Col3 ""
4 SQLCHAR 0 7 "" 4 Col4 SQL_Latin1_General_CP1_CI_AS
There are 4 columns in total, however some rows have missing values for Column 4, and but given there are no field separators (all columns have fixed width and data is truncated if needed), how should the format be written to define a row terminator to apply to Column 3 if Column 4 is null.
Thanks for your suggestions.
What Ad Hoc Tool Do You Use?
May 23, 2008
I'm in the process of delivering a SQL Server BI solution to a customer. I have the cube built, SSIS working and an SSRS package with several hundred reports. They would like to roll their own reports.
I've looked at ProClarity (or whatever MS calls it now) and Report Builder. Both seem to have their pros and cons.
What tool does the community recommend?
Thanks.
Is This The Right Tool?
Jul 20, 2006I think Service Broker is the right tool for what I want to do but need confirmation. Here is what I want to do.
Our company sells small business consulting services. When a client signs up with us, we put a server at their site that runs our app (using SQL Server 2005). Once the server is setup at their site and operational we constantly send certain information from that server to our central corporate server. There could be thousands of records every day being sent from each of these servers to our corporate server. We're using webservices now to transfer this data from each server but I'm afraid we're reaching a point where webservices will no longer work because of the volume of data.
1) I assume that Service Broker was created, in part at least, to address these types of situations?
2) If #1 is correct, is there any step by step examples/instruction that shows me how to use Service Broker to communicate between two SQL Server databases on two different servers?
Thanks very much.
Amos.
SubSonic Tool
Jul 3, 2007Hi, I'm not sure this is the right place to ask this question (please re-direct me if it isn't). I would like to learn about SubSonic tool:1. do you recommend this tool ? if so what are its best uses?2. is its license allows me to work with it for free for commercial uses? any license limitations I should be aware of for using it as a tool? thanks,
View 6 Replies View Related