> Trying to convert a mySQL database to MSSQL. Using Import data in SQL
> Server 2000, it works fine, however I get no primary keys defined on
> any of the tables, am I missing something? Or is there a tool that
> would do this?
>
> Many thanks.
>

> Trying to convert a mySQL database to MSSQL. Using Import data in SQL
> Server 2000, it works fine, however I get no primary keys defined on
> any of the tables, am I missing something? Or is there a tool that
> would do this?
>
> Many thanks.
>

> Hello Michael,
>
> Nope you are missing nothing. There is no way in DTS to do this,
> likewise you cannot do this with an Access DB. The only DB type that
> you can do this with is SQL Server --> SQL Server.
>
> A solution would be to read the metadata for the keys and indexes from
> MySQL and bulid the appropriate SQL Server equivalent statements and
> apply them.
>
> Allan Mitchell
> www.SQLDTS.com
> www.SQLIS.com
> www.Konesans.com
>> Trying to convert a mySQL database to MSSQL. Using Import data in
>> SQL Server 2000, it works fine, however I get no primary keys defined
>> on any of the tables, am I missing something? Or is there a tool
>> that would do this?
>>
>> Many thanks.
>>