2 Replies - 2360 Views - Last Post: 09 August 2013 - 08:49 AM Rate Topic: -----

#1 innessa  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 08-August 13

connection from sqlite to sql server change- issue

Posted 08 August 2013 - 07:46 PM

Hi,

I have a compiled code, which currently uses SQLITE connection (datastore). I was wondering if it is possible to change the connection string to use SQL Server database.

I would like to export the datastore to SQL server database, as we are having issues with the sqlite limit.

Thank you.
Inna
Is This A Good Question/Topic? 0
  • +

Replies To: connection from sqlite to sql server change- issue

#2 MATTtheSEAHAWK  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 137
  • View blog
  • Posts: 782
  • Joined: 11-September 10

Re: connection from sqlite to sql server change- issue

Posted 09 August 2013 - 06:57 AM

Here's something I found about sqlite converters: http://www.sqlite.or...=ConverterTools

I guess you could also write a script that reads your sqlite datastore and converts it into an sql server format. I'm not extremely experienced with databases, but that's what I can think of.
Was This Post Helpful? 0
  • +
  • -

#3 DblAAssassin  Icon User is offline

  • D.I.C Regular

Reputation: 43
  • View blog
  • Posts: 322
  • Joined: 11-May 13

Re: connection from sqlite to sql server change- issue

Posted 09 August 2013 - 08:49 AM

By looking at many sources I have found that DBConvert is pretty good, and reliable. Also there is Mozilla's SQLite Manager for Firefox Addon., it has the ability to export your SQLite Database to a .sql file, which you could then run in an SQL server, it's not the best but it's free.

I hoped this helped, feel free to post again, if you still need further assistance. :)
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1