Database

[mjc4118]

Is it possible to get a database definition or data map for the executed trade data ...so that I can use the trade data stored in the SQLCE database to perform some "what If" scenarios?

Or will i need to peek and poke at the records and discover on a trial an error basis?
Yes..the relationships are there in SQL .but table /field definitions would help save me a lot of time.

[NinjaTrader_RyanM1]

Hello mjc4118,

Unfortunately this is not supported. You may be able to get a view of the structure by opening the file in an external program - like visual studio.

[mjc4118]

Yes ...already done that ..the relationships are defined at least ....

Thanks

[MXASJ]

Search my user name on this site and at Big Mikes for info on my efforts to set up Merge Replication between SQL2008 and Ninja.

This tool helps you export the table schema from SQL CE to SQL:

http://sqlcetoolbox.codeplex.com/

On SQL2008 you need to install SQL CE 3.5 SP2 Tools, which is a PITA and requires a temporary registry edit if you are on IIS7. Note I believe from Beta 16 Ninja is using SQLCE SP2... but don't quote me on that.

It hit a brick wall with an IIS Authentication issue. I'm waiting for a house call by one of my SQL buds to help sort that out. If I get it to work I'll post back.