Copy setup tables using SQL

[barbola]

Rather than using DTS to copy setup tables from one company to another, is there an SQL statement that will do this?

I often create new companies and the DTS takes a long time even when I create a package because I have to go in and change the destination database on each table.

If I could just use a SQL statement and find/replace the database names I could re-use it each time.


Thanks!
Barb E.

 

[jymm]

so are you setting up test companies or new companies that have the setup like another?

On a monthly basis I copy one of our production companies over the top of TEST --- then it is like playing with our real data. Is this what you are looking for?

 

[jazgeek]

this is what I do.

create the dummy company as you would a normal company

do a sql backup of your current company
force restore it overtop the newly setup dummy company


takes all of 10 minutes depending on your database size.



-----------
and they wonder why they call it Great Pains!

jaz

 

[winthropdc]

You can also use my SnapShot tool to copy specific tables between companies, database, systems regardless of platform or account framework.

You might find this useful.

You can download SnapShot for free from the Development page of

http://www.winthropdc.com.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer
MBS Support - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[barbola]

I have done restoring from another db, but there is so much extra work involved with clearing tables and re-entering posting accounts and chequebook info everywhere.

Here is what I'm doing now: I created the DTS for each module, but instead of running it or making a package, I saved to VBScript.

Then I created a new VB project with those modules and am setting up a program where the user can select the source and destination DB's and run it from VB (exe file).

Has anyone attempted this? Am I trying to reinvent the wheel and wasting my time?

Anyway, it's good practice for me since I've just taken a VB course!

Thanks!
Barb E.

 

[klewis10367]

WinthropDC, what a Great Tool, this will come in handy.