Converting MySQL tablse to ASP.NET tables.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mr. R - 06 Feb 2008 21:04 GMT

Hi

I have a very large filewith data gathered from a homepage where I used PHP
scripting and MySQL. I would like to convert the table data to the database
I have in my ASP.NET Project which is a SQL Database to.

Any suggestions is aprecheated

Lars

Reply to this Message

Cowboy (Gregory A. Beamer) - 06 Feb 2008 22:34 GMT

If you can find a driver or provider, you can import into SQL Express
(free). Or you can use a MySQL Provider in ASP.NET. Of the two, I would
personally choose SQL Express, but I use the features that MySQL does not
have, so you have to decide.

Signature

Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

*************************************************

| Think outside the box!

*************************************************

> Hi
>
[quoted text clipped - 5 lines]
>
> Lars

Reply to this Message

bruce barker - 06 Feb 2008 23:29 GMT

i'd install mysql and use sqlserver's import. or you could create a php
webservice and use sqlservers ssis package or brokerage services to do the
import.

-- bruce (sqlwork.com)

> Hi
>
[quoted text clipped - 5 lines]
>
> Lars

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...