]
Sent: Monday, January 29, 2007 7:09 PM
To: CF-Talk
Subject: RE: Copying specific company data to a new database...
I use a tool called ApexSQL Diff. It's really useful for scripting
changes
between two databases (both data a structure). Therefore making it
relatively easy when moving
I have a MSSQL database w/a lot of tables. I've got to copy all of a
company's data from one database into a brand new database. The database
should have all its foreign keys/primary key relationships defined (with one
exception.)
I can write scripts by hand, but that will take a while. There's a
specific company data to a new database...
I have a MSSQL database w/a lot of tables. I've got to copy all of a
company's data from one database into a brand new database. The database
should have all its foreign keys/primary key relationships defined (with
one
exception.)
I can write
Doug,
Here is a little something that I found.
http://www.sharewareconnection.com/export-schema-to-sql-for-sql-server.htm
I can copy the entire database w/no problem. The issue is that I need to
take our database and create a copy that only contains the records from a
specific company.
So
Dan G. Switzer, II wrote:
I have a MSSQL database w/a lot of tables. I've got to copy all of a
company's data from one database into a brand new database. The database
should have all its foreign keys/primary key relationships defined (with one
exception.)
I can write scripts by hand, but
: Copying specific company data to a new database...
Doug,
Here is a little something that I found.
http://www.sharewareconnection.com/export-schema-to-sql-for-sql-server.htm
I can copy the entire database w/no problem. The issue is that I need to
take our database and create a copy that only
Niall.
-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED]
Sent: 29 January 2007 14:24
To: CF-Talk
Subject: Re: Copying specific company data to a new database...
Well, you could copy the entire database over then do a delete where the
company does not equal the company you want
I've got a script (used as a custom tag) that is built for SQL Server,
that will do a cascading database delete, calling itself as often as
necessary, based on the original record you want to delete. It requires
that the DB tables be properly set up with foreign keys etc. The script
digs
8 matches
Mail list logo
