Loop Through Tables, Pulling Through Each?

• benstewart84

  Grasshopper

  Points: 17

  More actions

  June 8, 2010 at 7:57 am

  #233466

  Hi guys, looking for some help.

  I'm looking to create a daily dump of data that I can work off of, only problem is there are around 100+ tables I'd like to download onto our SQL 2008 Server everyday from a SYBASE server.

  Is there an easy way to cursor through all the tables on SYBASE and save them to our DB? Even though they will have different columns in each table?

  Any help would be much appreciated.

  Thanks

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  June 8, 2010 at 2:30 pm

  #1177676

  Just a thought... could you accomplish what you require by setting up SYBASE as a linked server. If so .... read this:

  How to create a linked server in SQL Server 2005 for Sybase ASE 12.5 database using DataDirect's ODBC Driver and OLEDB provider? at:

  http://blogs.msdn.com/b/dataaccesstechnologies/archive/2009/11/12/how-to-create-a-linked-server-in-sql-server-2005-for-sybase-ase-12-5-database-using-datadirect-s-odbc-driver-and-oledb-provider.aspx

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]