This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » SQL and Databases » list all tables in a db then compare the...

list all tables in a db then compare the...
dave blohm Freaking Member Since: 11 Mar 2002 Posts: 96	Posted 05 Nov 2008 19:02:17 ...contents with all tables of the same name in another db basically, im duplicting a db in MS SQL 2005. once done, i need to verify that every record in db A is in db B i can list all tables in my db with <pre id=code><font face=courier size=2 id=code> USE myDBName SELECT * FROM information_schema.Tables</font id=code></pre id=code> but after that im lost. any help is greatly appreciated. - Doc Progress is made by the discontent. Edited by - daveblohm on 05 Nov 2008 19:03:00 ...contents with all tables of the same name in another db basically, im duplicting a db in MS SQL 2005. once done, i need to verify that every record in db A is in db B i can list all tables in my db with <pre id=code><font face=courier size=2 id=code> USE myDBName SELECT * FROM information_schema.Tables</font id=code></pre id=code> but after that im lost. any help is greatly appreciated. - Doc Progress is made by the discontent. Edited by - daveblohm on 05 Nov 2008 19:03:00

list all tables in a db then compare the...

dave blohm
Freaking Member

Since: 11 Mar 2002
Posts: 96

Posted 05 Nov 2008 19:02:17

...contents with all tables of the same name in another db

basically, im duplicting a db in MS SQL 2005. once done, i need to verify that every record in db A is in db B

i can list all tables in my db with
<pre id=code><font face=courier size=2 id=code>
USE myDBName
SELECT *
FROM information_schema.Tables</font id=code></pre id=code>

but after that im lost.

any help is greatly appreciated.

- Doc

Progress is made by the discontent.

Edited by - daveblohm on 05 Nov 2008 19:03:00

...contents with all tables of the same name in another db

basically, im duplicting a db in MS SQL 2005. once done, i need to verify that every record in db A is in db B

i can list all tables in my db with
<pre id=code><font face=courier size=2 id=code>
USE myDBName
SELECT *
FROM information_schema.Tables</font id=code></pre id=code>

but after that im lost.

any help is greatly appreciated.

- Doc

Progress is made by the discontent.

Edited by - daveblohm on 05 Nov 2008 19:03:00

Reply to this topic

Message
Reply

Live Support

Visit All Zones

Latest Extensions

Premium Articles

DMXzone Updater

Our Sponsors

Find Us on Facebook

Featured Extension

Extensions Yearly Subscription

Tired of purchasing many extensions just to finish up your project. Now we have a solution for you. For a small fee you have access to over 70 high-quality (all DMXzone extensions) and growing Dreamweaver extensions for a year period!

Additionally, we're working on many new ones, which will be available for every subscription holder when released!

Forums

list all tables in a db then compare the...

Reply to this topic

Live Support

On Sale

DMXzone Tabs

Advanced HTML Editor 3

Image Gallery Add-on

File Manager Add-on