I'm trying to do an SQL Server dump of a couple of tables in a database (Microsoft SQL Server). We don't have write access to the DB, so we can't do what I was originally thinking (create temp db, copy tables (minus the columns we don't want into the temp db, and then dump that db). I really can't figure out a way to do this. A csv expo...
Any idea how to go about formatting the data so I can export from my app data in excel format or even a simple table would be okay, how are people getting stuff out of the phone? This particular app is about keeping track of money, so i can pretty much turn everything into nsstrings but how do I: A. format the strings so the fields ar...
I have FK and PK all over my db and table data needs to be specified in a certain order or else I get FK/PK insertion errors. I'm tired of executing the wizard again and again to transfer data one table at a time. In the SQL Server export data wizard there is an option to "Write a query to specify the data to transfer". I'd like to writ...