Menu
Is there any free tool or plug-in for Visual Studio to convert the SQL tables to entity, model, facade and DAO classes? I am working on SQL Server 2008, Visual Studio 2008 and C#.
374
The AWS Schema Conversion Tool (AWS SCT) makes heterogeneous database migrations predictable. It automatically converts the source database schema and a majority of the database code objects, including views, stored procedures, and functions, to a format compatible with the target database.
AWS SCT is a free download available on the AWS website. You can install AWS SCT on any Windows, Fedora, macOS, or Ubuntu server that has access to your source and target databases.
Various Programming Languages like C# and . Net are compatible with Oracle and Microsoft SQL Server. Also, they follow the same logic with each database in most cases. Here are a few concepts common for all Databases.
You can use the AWS Schema Conversion Tool (AWS SCT) to convert your existing database schema from one database engine to another. You can convert relational OLTP schema, or data warehouse schema.
Have you tried LINQ to SQL (although the future of LINQ to SQL is a bit vague)?
If you were using Visual Studio 2010 you'd get Entity Framework tooling in the box.
There's also NHibernate which has a variety of free tooling:
Free NHibernate helper tools? (Stack Overflow)
101
Try using SQLMetal from Microsoft. The files aren't pretty, but they work and also provide LINQ functionality. It's also free :)
I've used it first hand, and it works very well. The beauty of it is, it generates everything from one command.
Hope this helps.
45
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
