Or what is the best way? I had an Idea to create linked servers and that once linked I could find a stored proceedure somewhere that would run and get all the table names and data and create them on my MS SQL 2008 Server. I only want a snapshot to be taken I do not need the data to be updated at all.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux.
Script may need to be modified depending on OS-installation.
Please deploy and verify the script in a test environment.