"Bit Byte" <root@your.box.com> wrote in message
news:wYadnb7AMpfs3kHYnZ2dnUVZ8qO3nZ2d@bt.com...
>I seem to be spending too much time "Googling" for info on what should be a
>a fairly straight forward task - porting an mySQL db schema over to SQL
>Server.
>
> The T-SQL documentation I have seen so far do not give any useful (i.e.
> detailed enough) examples. My tables generally tend to have indices, and
> both PKs and FKs so I need an example that shows all of this in one table
> (no such luck in my search so far) - and it is causing me to waste
> valuable time.
>
> I have included one of the tables in my schema - I would be grateful if
> someone can give me the equivalent T-SQL statements for recreating the
> table declared below, in SQL Server using T-SQL. Once I receive that, I
> should be able to work out the relevant mappings for the rest of my schema
> then.
>
> Here's a sample table from my MySQL schema:
>
>
> CREATE TABLE IF NOT EXISTS country_def (
> id int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
> name varchar(64) NOT NULL,
> gzone_id int unsigned NOT NULL,
> ccy_id int unsigned NOT NULL,
> regtyp_id int unsigned NOT NULL,
> eu_mbr smallint unsigned NOT NULL default 0,
> createdate timestamp NOT NULL default CURRENT_TIMESTAMP,
> creator_id int unsigned NOT NULL,
>
> INDEX (eu_mbr),
> INDEX (gzone_id),
> INDEX (ccy_id),
> INDEX (regtyp_id),
>
> FOREIGN KEY (gzone_id) references gzone_def(id),
> FOREIGN KEY (ccy_id) references currency_def(id),
> FOREIGN KEY (regtyp_id) references region_type_def(id)
>
> ) ENGINE=InnoDB ;
>
> CREATE UNIQUE INDEX idx_ctry ON country_def (gzone_id, name(8)) ;
>
>
>
>
> PS: Sorry for the cross posting - I'm not sure which would be the most
> appropriate ng

On Feb 21, 8:09 am, Bit Byte <r...@your.box.com> wrote:
> I seem to be spending too much time "Googling" for info on what should
> be a a fairly straight forward task - porting an mySQL db schema over to
> SQL Server.
>
> The T-SQL documentation I have seen so far do not give any useful (i.e.
> detailed enough) examples. My tables generally tend to have indices, and
> both PKs and FKs so I need an example that shows all of this in one
> table (no such luck in my search so far) - and it is causing me to waste
> valuable time.
>
> I have included one of the tables in my schema - I would be grateful if
> someone can give me the equivalent T-SQL statements for recreating the
> table declared below, in SQL Server using T-SQL. Once I receive that, I
> should be able to work out the relevant mappings for the rest of my
> schema then.
>
> Here's a sample table from my MySQL schema:
>
> CREATE TABLE IF NOT EXISTS country_def (
> id int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
> name varchar(64) NOT NULL,
> gzone_id int unsigned NOT NULL,
> ccy_id int unsigned NOT NULL,
> regtyp_id int unsigned NOT NULL,
> eu_mbr smallint unsigned NOT NULL default 0,
> createdate timestamp NOT NULL default CURRENT_TIMESTAMP,
> creator_id int unsigned NOT NULL,
>
> INDEX (eu_mbr),
> INDEX (gzone_id),
> INDEX (ccy_id),
> INDEX (regtyp_id),
>
> FOREIGN KEY (gzone_id) references gzone_def(id),
> FOREIGN KEY (ccy_id) references currency_def(id),
> FOREIGN KEY (regtyp_id) references region_type_def(id)
>
> ) ENGINE=InnoDB ;
>
> CREATE UNIQUE INDEX idx_ctry ON country_def (gzone_id, name(8)) ;
>
> PS: Sorry for the cross posting - I'm not sure which would be the most
> appropriate ng