Export ASP.net data to MySQL database

Question

I'm working on redesigning a database for a client. The client's original database was set up using ASP.net. However, my redesign involves creating a MySQL database (MySQL'll meld much better with the redesigned website).

Is there a way to export the data from the ASP.net set up so that I can include it in the MySQL database?

ASP.Net is a front end technology like php; it is not a persistent storage. There is nothing to import from ASP.Net to MySQL. Do you mean importing data from MS SQL to MySQL? — Win
– Win, Commented Oct 20, 2016 at 23:50
@win, sorry, I'm pretty new to ASP.Net. The previous web developer gave me a zip file with a bunch of ASP files in it, so I'm just trying to get to the data. Yes, I think it would be a MS SQL to a MySQL conversion. — sleepy_daze
– sleepy_daze, Commented Oct 21, 2016 at 11:15

Dipu Raj · Accepted Answer · 2016-10-21 04:19:58Z

2

If the migration is from Microsoft SQL Server to MySQL, this might help

Migrating from ms sql server to mysql using workbench migration wizard

answered Oct 21, 2016 at 4:19

Dipu Raj

1,8944 gold badges33 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

sleepy_daze Over a year ago

If I have been given a zip folder with the ASP.net files in it, what would be the best way to get these to run locally so I can get Workbench to detect the database? I'm thinking I can put them in an XAMPP folder and have Workbench point to that, maybe?

Dipu Raj Over a year ago

ASP.net and the database is two different things. What you have to get is the connection string of your database (MS SQL, MySQL). You may find the MSSQL on web.config file of your ASP.net project and the MySQL you might have known. Use that connection string on the migration software and it will do the migration of the database for you (the database migration not the whole ASP.Net project).

sleepy_daze Over a year ago

Gotcha. That makes sense. Thanks for your help!

Collectives™ on Stack Overflow

Export ASP.net data to MySQL database

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related