I often work in a local environment and later need to migrate data to a remote database server. If the ports are open on the remote server, I can just export the data. Often this is not the case. In the past, I have either
- Export the data, FTP it to the other location and import the data (what a pain!)
- Used code I wrote to export the data to INSERT statements, copy/paste text to other location and execute scripts (not too bad)
I was looking for an easier approach and came across Narayana Vyas Kondreddi's website. He has written a ton of code (VB and SQL) to do a lot of the everyday things we do.
Here's a link to a "Procedure to script your data (to generate INSERT statements from the existing data)":
http://vyaskn.tripod.com/code.htm#insertsIt's great. It installs in the master database and is available to all users for all databases.
It even has options to filter results, omit certain data types, get only n rows, and much more.
Be sure to check it out for yourself.
In case the site ever shuts down, here's a
link to the SQL 2005 script.
Announced this morning on Google.com...
As you may know, for every $1 you spend on AdWords, you can process $10 of Google Checkout sales for free. Just in time for the holidays, we're giving you even more by processing your Google Checkout sales for free through the end of 2007! Here's how it works:
- From November 8, 2006 through December 31, 2007, we'll process your Checkout transactions for free, even if you aren't an AdWords advertiser. If you're already an AdWords advertiser, we'll process your Checkout transactions for free regardless of what you spend on AdWords.*
- Valid Checkout orders you receive during the promotion will automatically qualify.
- You can take full advantage of this promotion by encouraging your buyers to use Google Checkout on your site.
- Other applicable fees (e.g. chargeback fees) may apply. This promotion is subject to the Google Checkout Terms of Service. Google may revoke the promotion for accounts that do not comply with these terms.
On January 1, 2008, the standard transaction fee will apply again. Also, if applicable, your regular free transaction processing (based on your December, 2007 AdWords spend) will resume.
Using Google Checkout to increase sales and lower costs during this busy holiday season has never been easier. If we can do anything else to help, feel free to drop us a line. Happy holidays from Google Checkout!
* AdWords advertisers: Because this promotion begins on 11/8/06, the free transaction processing based on your AdWords spend will still apply to your Checkout sales from 11/1/06 through 11/7/06. Any Checkout orders you receive and process from 11/8/06 through 12/31/07 will then be eligible for free processing under this promotion.