.NET , SQLite to SQLServer Entity Framework migration
-
Hi, I need help in "how to do it" I have an existing .NET application which use Sql Entity Framework with SQLite databse. This application is deployed and used by client and there is a production database . Now the client need to migrate this database to SQLServer. So what I need is to migrate the SQLite database to SqlServer and make the necessary in code using Entity Framework always. My question please is what is the best practice to accomplish this and steps to follow. Thanks for help
-
Hi, I need help in "how to do it" I have an existing .NET application which use Sql Entity Framework with SQLite databse. This application is deployed and used by client and there is a production database . Now the client need to migrate this database to SQLServer. So what I need is to migrate the SQLite database to SqlServer and make the necessary in code using Entity Framework always. My question please is what is the best practice to accomplish this and steps to follow. Thanks for help
I think defining the "best practice" is a little arbitrary, there are very few different ways to do the migration. Google[^] seems to show a simple method. As for EF, surely you simply give it a new connection string (I despise EF so never use it).
Never underestimate the power of human stupidity RAH
-
I think defining the "best practice" is a little arbitrary, there are very few different ways to do the migration. Google[^] seems to show a simple method. As for EF, surely you simply give it a new connection string (I despise EF so never use it).
Never underestimate the power of human stupidity RAH
-
Thanks for reply, But what I asked for is using code will be more better than using standard tools ? and if yes how achieve this ? Thank you
If you have to ask, then it is better to use standard tools. Recreate the database-tables in SQL Server and see if you can export the data as CSV or similar.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
-
Thanks for reply, But what I asked for is using code will be more better than using standard tools ? and if yes how achieve this ? Thank you
I would use the standard tool UNLESS it is something that needed repeating regularly. For a one off migration do it manually.
Never underestimate the power of human stupidity RAH
-
Hi, I need help in "how to do it" I have an existing .NET application which use Sql Entity Framework with SQLite databse. This application is deployed and used by client and there is a production database . Now the client need to migrate this database to SQLServer. So what I need is to migrate the SQLite database to SqlServer and make the necessary in code using Entity Framework always. My question please is what is the best practice to accomplish this and steps to follow. Thanks for help
Going through a review of websites will give you much insight about it which you can’t know by simply visiting it. Our expert Allassignmenthelp.co.uk Reviews go through many websites each month to select only the best. This makes students aware of websites offering best Assignments.