You could export it via DTS

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #277,149 by ChrisR 1/1/07 6:55:43 PM Reply	You could export it via DTS to some third format (Excel, MDB, text, etc...) and then import via another DTS task. Another method I've used in the past was to just use a set of SQL queries that generate insert statements as output ('INSERT INTO MyTable VALUES(....)') and then run it as a script on the target server. I did have to write the queries by hand for each table, but there's probably a way to automate it if you really need to.
Post #277,151 by tuberculosis 1/1/07 7:17:58 PM Reply	I'd go with the last strategy Do a little digging on how to query for table formats, and how to get a list of tables, constraints, indexes, etc. It is all available via sql. Use this to write a generic dump script that you can feed to the other db. Should take no more than a day of concentrated effort to do this. [link\|http://www.blackbagops.net\|Black Bag Operations Log] [link\|http://www.objectiveclips.com\|Artificial Intelligence] [link\|http://www.badpage.info/seaside/html\|Scrutinizer]
Post #277,239 by tangaroa 1/2/07 11:43:47 PM Reply	Thanks, both of you Must've forgotten to hit save after preview. Let's try that again... I finally found [link\|http://vyaskn.tripod.com/code/generate_inserts.txt\|some code] that should turn a table into SQL inserts. If it works, it should be easy enough to make a list of tables and plug it in, which should be all I need.

Backing up SQL Server 2005 to 2000 - (tangaroa) - (5) - Jan. 1, 2007, 05:41:33 PM EST

How much data? - (crazy) - (1) - Jan. 1, 2007, 06:09:20 PM EST

Re: How much data? - (tangaroa) - Jan. 2, 2007, 10:47:01 PM EST

You could export it via DTS - (ChrisR) - (2) - Jan. 1, 2007, 06:55:43 PM EST

I'd go with the last strategy - (tuberculosis) - (1) - Jan. 1, 2007, 07:17:58 PM EST

Thanks, both of you - (tangaroa) - Jan. 2, 2007, 11:43:47 PM EST

We have a moral imperative.
69 ms