MSSQL Access under Linux

[Michael Hipp]

I would think you would have better luck doing a dump / restore operation to 
bring the data in whole hog. I've been getting my first taste of MSSQLserver 
the last few days (spit, gag, wretch) but it does seem to have some reasonable 
command line tools that could be used to automate a dump / restore.

Michael

Shawn Tayler wrote:
> Hi Guys,
> 
> I've been trying to find a way to access a database running on a WindBlows
> server and MS-SQL.  I plan to port the data into my PostgreSQL database
> for reports and archiving.  I am looking for a simple commandline
> interactive client, rather like the psql app for Postgres.  I'll be taking
> the results of some queries and dumping them to flat files that can be
> precessed and loaded into my "Real" database. 
> 
> Suggestions as to where to look?  
> 
> I've been trying dbtcp but it won't build, example:
> 
> shawn at shop:~/dbtcp-0.1.18a$ make
> ar cr libs/libdbftp.a socket.o my_error.o protocol.o utils/my_string.o
> utils/my_array.o utils/my_bstring.o make -C dbug -e libdbug.a
> make[1]: Entering directory `/home/shawn/dbtcp-0.1.18a/dbug'
> gcc -O    -c -o dbug.o dbug.c
> dbug.c:210: error: conflicting types for 'fprintf'
> dbug.c:210: note: a parameter list with an ellipsis can't match an empty
> parameter name list declaration dbug.c:210: error: conflicting types for
> 'fprintf' dbug.c:210: note: a parameter list with an ellipsis can't match
> an empty parameter name list declaration dbug.c:213: warning: conflicting
> types for built-in function 'malloc' dbug.c:214: warning: conflicting
> types for built-in function 'strlen' make[1]: *** [dbug.o] Error 1
> make[1]: Leaving directory `/home/shawn/dbtcp-0.1.18a/dbug'
> make: *** [dbtcp] Error 2
> shawn at shop:~/dbtcp-0.1.18a$                            
> 
> Here's the section of code that fails:
> 
> IMPORT int atoi ();             /* Convert ascii to integer */
> IMPORT VOID exit ();            /* Terminate execution */
> IMPORT int fclose ();           /* Close a stream */
> IMPORT FILE *fopen ();          /* Open a stream */
> IMPORT int fprintf ();          /* Formatted print on file */ <------  HERE
> IMPORT int vfprintf ();         /* Varargs form of fprintf */
> IMPORT VOID free ();
> IMPORT char *malloc ();         /* Allocate memory */
> IMPORT int strlen ();
> 
> Which looks good as far as I can tell....
> 
> Plus it requires a service app to be running on the MS-SQL box,
> something I'm not totally comfortable with.  
> 
> What wisdom can you bestow oh great list?
> 
> Shawn
> _______________________________________________
> Linux-users mailing list ( Linux-users at linux-sxs.org )
> Unsub/Password/Etc: http://mail.linux-sxs.org/cgi-bin/mailman/listinfo/linux-users
> 
> Need to chat further on this subject? Check out #linux-users on irc.linux-sxs.org !