database - Extract ER Diagram from an existing DB (SQL Server) -


i have pretty messy db weird tangle of keys. can suggest me software (better if it's free) can extract er schema db?

you can use er-studio, ca-erwin , toad has reverse engineering capabilities.


Comments

Post a Comment

Popular posts from this blog

bash - How do you programmatically add a bats test? -

i'd have bats test created every file in directory, i'm not sure best way done is. approach below creates single test when there many files in directory. #!/usr/bin/env bats in $(ls) @test "testing $i" { pwd } done to extract ls output not batter solution go wrong on filenames spaces. you can below shopt -s nullglob file in /dir/* //test command on $file done shopt -u nullglob you can using find command also find /some/directory -maxdepth 1 -type f -exec cmd option {} \;
Read more

Unable to open serial port using Putty to bluetooth device on windows 7 64 bit -

i working on dell windows 7 pro 64 bit machine. trying use on board bluetooth adapter comm homegrown bluetooth device using putty , serial port... device pairs computer. hoever, putty unable open serial port bluetooth device mapped/assigned to. tried putty 0.60 , 0.63. suggestions/help appreciated. thanks! pertinent details: baud: 57600 port: outgoing: com3 'spp dev' incoming: com4 adapter: intel wireless bluetooth adapter 4.0 has called microsoft bluetooth enumerator... putty version 0.60: 57600 com3 8 bits 1 stop bit no parity xon/xoff line discipline options: force on , force on putty version 0.63: 57600 com3 8 bits 1 stop bit no parity xon/xoff line discipline options: force on , force on when run putty 0.63, notice ssh selected connection type on right panel. have tried changing serial , updating com port configuration?
Read more

java - Getting exception in JDBC thin driver -

i try run query using java , below mentioned program import java.sql.connection; import java.sql.drivermanager; import java.sql.resultset; import java.sql.statement; import javax.naming.spi.dirstatefactory.result; public class oracleconn { public static void main(string[] args) { try { class.forname("oracle.jdbc.driver.oracledriver"); connection con = drivermanager.getconnection("jdbc:oracle:thin:@localhost:1521:yglobal","user","user"); statement stmt = con.createstatement(); resultset rs = stmt.executequery("select empid empmaster"); while(rs.next()) system.out.println(rs.getint(1)); con.close(); } catch (exception e) { e.printstacktrace(); }} } but when tried run program getting exception java.sql.sqlexception: ora-01756: quoted string not terminated @ oracle.jdbc.driver.databasee...
Read more