IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / I'd go with the last strategy
Post #277,151
by tuberculosis
Picture of tuberculosis
1/1/07 7:17:58 PM
Reply
New 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
New 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

Gifts to acquaintances and coworkers should be delivered with as much warmth and sincerity as you can fake.
106 ms