Hey all, i was wondering what do you guys use for database seeding (initial data population) from csv or xls files. in rails i'm using the test Fixture in order to populate from .csv files and it works flawlessly.
i should mention that the data needs to be inserted with pre-defined IDs that are in the data files (csv) even if the column is autogenerated.
Hey all, i was wondering what do you guys use for database seeding (initial data population) from csv or xls files. in rails i'm using the test Fixture in ...
... If this seed is just for testing, would load the csv files into memory, and mock your data layer from them. As to inserting with pre-defined identity...
But if you actually want to test your database calls, that is fine in .net as well. I've also used Visual Studio Team System Database Edition (VSTS DataDude), ...
well basically i need a form of initial data. i do my tests with mocking so i don't need it for testing. the problem is, i'm using several statistical...
What I do right now is insert the test data through my application and then do a database dump. But I don't like this approach very much. It is error prone and...
I just thought I'd point out that "an MSDN subscription" isn't standard. With the MSDN Pro running $1200 and "Visual Studio Team System 2008 Database Edition...
actually rhino ETL is an interesting proposition. as i remember he uses some sort of library that works nicely with files i may research using that, thanks!...
+1 for Rhino.ETL I made the wise move of moving from SSIS to Rhino.ETL. One of my better decisions Cheers Paul Cowan Cutting-Edge Solutions (Scotland) ...
No it isn't standard...but nothing else is either. Anyway, there are a lot of people with access to those tools, but don't know it. RedGates tools are also...
Don't buy MSDN at retail. Talk to your local Microsoft rep. They'll work with you. Also the 10k is only the initial year. Renewals are significantly less. Even...
I don't actually pay retail and am actually a member of the Partner program (the Microsoft Action Pack is one of the better deals in software: 10 prod Office...
Ahhhh...I see what you're saying. Agreed, I think people should qualify what they mean when they say MSDN Subscription because it goes as low as "library"...
Just to be clear.. you don't have to deal with the XML files yourself. It uses standard dataset-xsd, so you can use visual studio dataset-editor and C# code to...
Having problems with message search?
Offline 
Send Email