viewpoint-particle

Author Topic: Need Help to Open and Load SQLServer 2012 DB from WinBatch  (Read 2486 times)

CoreyGlenn

  • Newbie
  • *
  • Posts: 5
Need Help to Open and Load SQLServer 2012 DB from WinBatch
« on: January 15, 2014, 12:38:06 pm »
Though I am very familiar with WinBatch programming using flat files, working with databases is a first for me.
Though not familiar with .NET, ADO, or CLR, I am willing to do learn the best approach to open and load and query my SQLServer 2012 Database using winbatch.

Both the script and database are running on VMWare server with Windows Server 2008 (64bit) as the OS
I'm running 32 bit version of Winbatch.
The access to the database is a trusted connection (using windows authentication).

Does anyone have any straightforward examples to share? Also, what documentation would you suggest to better understand what's happening behind the scenes?

Thanks,

Corey

Deana

  • Wilson WindowWare Tech Support
  • Pundit
  • *****
  • Posts: 1183
  • WinBatch® can do it.
    • WinBatch Tech Support Database
Deana F.
Technical Support
Wilson WindowWare Inc.

stanl

  • Pundit
  • *****
  • Posts: 951
Re: Need Help to Open and Load SQLServer 2012 DB from WinBatch
« Reply #2 on: January 16, 2014, 09:06:10 am »
Adding to what Deana wrote. I played around with the 2012 Trial, and scripts written for 2005/2008 worked with it. So don't be shy to try one of the multiple scripts posted in the tech db (even if they say tested with 2008).

The only downside which has nothing to do with coding is that after I removed the trial and reinstalled 2008, the 2012 .mdfs cannot be used with an earlier version; so I have about 2 gig of data I can't open.