in

System.Data.SQLite

An open-source, enhanced version of the SQLite database engine for Windows

How to move the data from SQL Server 2000 to SQLite??

Last post 06-14-2008 12:15 AM by liron. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-21-2008 6:29 AM

    How to move the data from SQL Server 2000 to SQLite??

    My site was developed by asp.net + SQLServer 2000

    I want to change the database to Sqlite

    Any response was appreciated!

  • 01-22-2008 2:06 PM In reply to

    Re: How to move the data from SQL Server 2000 to SQLite??

    SQLite is not for everyone.  My experience has been that for small websites, SQLite is fine.  However if your site has lots of traffic this might not be a good idea.  If you've got lots of stored procedures, the pain of migration might be quite severe.  If you're considering switching databases, you really need to do an in depth analysis of the benefits and costs which is more than can reasonably be discussed here.
  • 06-14-2008 12:15 AM In reply to

    • liron
    • Top 500 Contributor
    • Joined on 06-14-2008
    • Posts 3

    Re: How to move the data from SQL Server 2000 to SQLite??

    Maybe it's too late but I've developed a very simple converter (in C#) that does the conversion. Go to http://www.codeproject.com/KB/database/convsqlservertosqlite.aspx

    Good Luck

    Liron 

Page 1 of 1 (3 items)
Powered by Community Server (Commercial Edition), by Telligent Systems