Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It is now :-) <a href="http://pastebin.com/6ATaLuNs" rel="nofollow">http://pastebin.com/6ATaLuNs</a></p> <p>I have been able to load the database into my own SQL Server installation by converting the data types from MySql to SQL Server version, removing MySql-specific code (such as engine specification), and using <code>CHECK</code> constraints in place of the <code>enum</code>'s. Here's my rough attempt at converting the table structure script:</p> <pre><code>BEGIN TRANSACTION CREATE TABLE city ( ID int NOT NULL, Name char(35) NOT NULL DEFAULT '', CountryCode char(3) NOT NULL DEFAULT '', District char(20) NOT NULL DEFAULT '', Population int NOT NULL DEFAULT '0', PRIMARY KEY (ID) ) CREATE TABLE country ( Code char(3) NOT NULL DEFAULT '', Name char(52) NOT NULL DEFAULT '', Continent varchar(20) CHECK(Continent in ('Asia','Europe','North America','Africa','Oceania','Antarctica','South America')) NOT NULL DEFAULT 'Asia', Region char(26) NOT NULL DEFAULT '', SurfaceArea decimal(10,2) NOT NULL DEFAULT '0.00', IndepYear smallint DEFAULT NULL, Population int NOT NULL DEFAULT '0', LifeExpectancy decimal(3,1) DEFAULT NULL, GNP decimal(10,2) DEFAULT NULL, GNPOld decimal(10,2) DEFAULT NULL, LocalName char(45) NOT NULL DEFAULT '', GovernmentForm char(45) NOT NULL DEFAULT '', HeadOfState char(60) DEFAULT NULL, Capital int DEFAULT NULL, Code2 char(2) NOT NULL DEFAULT '', PRIMARY KEY (Code) ) CREATE TABLE countrylanguage ( CountryCode char(3) NOT NULL DEFAULT '', Language char(30) NOT NULL DEFAULT '', IsOfficial char(1) CHECK(IsOfficial IN ('T','F')) NOT NULL DEFAULT 'F', Percentage decimal(4,1) NOT NULL DEFAULT '0.0', PRIMARY KEY (CountryCode,Language) ) COMMIT TRANSACTION </code></pre> <p>You can run the INSERT statements as-is if you make the following changes (you will have to manually pull out the <code>INSERT</code> statements by removing the <code>CREATE TABLE</code> code in the MySql script):</p> <ol> <li>Remove all instances of back-tick (`) (Find-Replace ` with nothing in an editor)</li> <li>Replace all instances of <code>\'</code> with <code>''</code> for SQL Server's quote escaping</li> </ol>
    singulars
    1. This table or related slice is empty.
    1. POMySQL "World" database for MS SQL Server
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USmellamokb
    1. USmellamokb
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POMySQL "World" database for MS SQL Server
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHmm I'll try this out. I knew there were some differences between the different SQL flavors out there but wasn't sure exactly what. My ideal goal would be just to have a .bak backup made of the database that would work off the shelf for MS SQL.
      singulars
      1. PO
      1. USPhil
    2. COThe code at your link worked great! :)
      singulars
      1. PO
      1. USPhil
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload