ssc pulldata

[sbechet]

Add ssc pulldata to save data in .sql format

[winzig]

This would be awesome to have for lookup tables. Perhaps some way to designate which of your tables you want to track in this way.

[winzig]

@justinlettau I'm trying to figure out how to use this new feature. It looks like we need to define a data array of globs in the config .json file, which I've done:

"data": ["dbo.Coupons", "dbo.DiscussionTopics", "dbo.Lookup*", "dbo.Partners", "dbo.Webheads"]

I'm running ssc pull on the command line, but I'm not seeing anything new generated. Am I missing anything? Thanks!

[justinlettau]

@winzig Yeah, the data glob is correct. Are you running v1.8.0?

[winzig]

Yep

[justinlettau]

Well, it should be generating files in the _sql-database/data/ directory. Can you post your config?

[winzig]

The only other thing defined in my config is my SQL connection properties. So it's just that, and the data glob array. Do I need something else defined in there to tell it to do the data pull?

[winzig]

hmmm... I think I see the issue. It looks like I have both a global and a local installation of ssc. The local one appears to be 1.7.1. Sorry!

[justinlettau]

Glad you figured it out!

[winzig]

It's mostly working for me now, but data entry for "dbo.Lookup*" seems to cause it to choke. I'm guessing this type of file glob is not allowed?

[justinlettau]

Hmm, I guess I the docs are wrong (sorry). I think currently is is a list of table names, not a glob.