I have a report generated in Crystal 10 that is exported to the SQL server
into its own DB. I finally go the report filtered out enough to where it put
s
each person with their designated type (i.e. Store location). My question
isthis: is it possible to have a query of some sort to look at the employee
type and copy all corresponding people in subsequesnt tables that are
associated with that type to another Table that actually corresponds with
their actual store? The 4 Fields that are generated by Crystal
are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it is
possible to analyse the Employee_Type column, then any thing that is
corresponding with says DA and has coresponding information in the tables
across from it and then copy the information from those columns to the
correspoding columns in another table?"Chris Chandler" <see@.top.com> wrote in message
news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>I have a report generated in Crystal 10 that is exported to the SQL server
> into its own DB. I finally go the report filtered out enough to where it
> puts
> each person with their designated type (i.e. Store location). My question
> isthis: is it possible to have a query of some sort to look at the
> employee
> type and copy all corresponding people in subsequesnt tables that are
> associated with that type to another Table that actually corresponds with
> their actual store? The 4 Fields that are generated by Crystal
> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it
> is
> possible to analyse the Employee_Type column, then any thing that is
> corresponding with says DA and has coresponding information in the tables
> across from it and then copy the information from those columns to the
> correspoding columns in another table?
It is probably possible, but it would be much easier to help you if you
could post the DDL and some INSERTS with sample data.
What does the Crystal table look like when it is finished? Give us the
CREATE TABLE statement and some sample INSERTs.
What do your other tables look like that you would like to pull the data
from based on the crystal table's TYPE column.
What do you want your final output to look like or your final table? Give
us the CREATE TABLE statement for that as well and we should be able to help
you out.
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Hm I would gladyl do so but I am so new to SQL and all that I am not sure
where or how to get that exact info. When I go to export it, I just use the
Export Wizard|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Also, what happens is when Crystal generates the report, it has 1 table
with 4 fields as stated above. These fields have about 1400 records per
field. They are sorted by Employee Type (ie the store they work at). Again
this is all stored by type in one field. To a point this is fine, but is
there a way to either get Crystal to create 11 tables out of the one big
report or do I need some sort of code or query to break this down when it
is exported?
I am real real new to this so have patience with me. I am looking thru al
teh help files and even going thru the SBS SQL Server 2000 programming book
from Microsoft.
Showing posts with label generated. Show all posts
Showing posts with label generated. Show all posts
Sunday, March 25, 2012
Copying tables based on information
I have a report generated in Crystal 10 that is exported to the SQL server
into its own DB. I finally go the report filtered out enough to where it puts
each person with their designated type (i.e. Store location). My question
isthis: is it possible to have a query of some sort to look at the employee
type and copy all corresponding people in subsequesnt tables that are
associated with that type to another Table that actually corresponds with
their actual store? The 4 Fields that are generated by Crystal
are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it is
possible to analyse the Employee_Type column, then any thing that is
corresponding with says DA and has coresponding information in the tables
across from it and then copy the information from those columns to the
correspoding columns in another table?"Chris Chandler" <see@.top.com> wrote in message
news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>I have a report generated in Crystal 10 that is exported to the SQL server
> into its own DB. I finally go the report filtered out enough to where it
> puts
> each person with their designated type (i.e. Store location). My question
> isthis: is it possible to have a query of some sort to look at the
> employee
> type and copy all corresponding people in subsequesnt tables that are
> associated with that type to another Table that actually corresponds with
> their actual store? The 4 Fields that are generated by Crystal
> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it
> is
> possible to analyse the Employee_Type column, then any thing that is
> corresponding with says DA and has coresponding information in the tables
> across from it and then copy the information from those columns to the
> correspoding columns in another table?
It is probably possible, but it would be much easier to help you if you
could post the DDL and some INSERTS with sample data.
What does the Crystal table look like when it is finished? Give us the
CREATE TABLE statement and some sample INSERTs.
What do your other tables look like that you would like to pull the data
from based on the crystal table's TYPE column.
What do you want your final output to look like or your final table? Give
us the CREATE TABLE statement for that as well and we should be able to help
you out.
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>>I have a report generated in Crystal 10 that is exported to the SQL
>>server
>> into its own DB. I finally go the report filtered out enough to where
>> it puts
>> each person with their designated type (i.e. Store location). My
>> question isthis: is it possible to have a query of some sort to look at
>> the employee
>> type and copy all corresponding people in subsequesnt tables that are
>> associated with that type to another Table that actually corresponds
>> with their actual store? The 4 Fields that are generated by Crystal
>> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
>> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if
>> it is
>> possible to analyse the Employee_Type column, then any thing that is
>> corresponding with says DA and has coresponding information in the
>> tables across from it and then copy the information from those columns
>> to the correspoding columns in another table?
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Hm I would gladyl do so but I am so new to SQL and all that I am not sure
where or how to get that exact info. When I go to export it, I just use the
Export Wizard|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>>I have a report generated in Crystal 10 that is exported to the SQL
>>server
>> into its own DB. I finally go the report filtered out enough to where
>> it puts
>> each person with their designated type (i.e. Store location). My
>> question isthis: is it possible to have a query of some sort to look at
>> the employee
>> type and copy all corresponding people in subsequesnt tables that are
>> associated with that type to another Table that actually corresponds
>> with their actual store? The 4 Fields that are generated by Crystal
>> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
>> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if
>> it is
>> possible to analyse the Employee_Type column, then any thing that is
>> corresponding with says DA and has coresponding information in the
>> tables across from it and then copy the information from those columns
>> to the correspoding columns in another table?
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Also, what happens is when Crystal generates the report, it has 1 table
with 4 fields as stated above. These fields have about 1400 records per
field. They are sorted by Employee Type (ie the store they work at). Again
this is all stored by type in one field. To a point this is fine, but is
there a way to either get Crystal to create 11 tables out of the one big
report or do I need some sort of code or query to break this down when it
is exported?
I am real real new to this so have patience with me. I am looking thru al
teh help files and even going thru the SBS SQL Server 2000 Programming book
from Microsoft.
into its own DB. I finally go the report filtered out enough to where it puts
each person with their designated type (i.e. Store location). My question
isthis: is it possible to have a query of some sort to look at the employee
type and copy all corresponding people in subsequesnt tables that are
associated with that type to another Table that actually corresponds with
their actual store? The 4 Fields that are generated by Crystal
are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it is
possible to analyse the Employee_Type column, then any thing that is
corresponding with says DA and has coresponding information in the tables
across from it and then copy the information from those columns to the
correspoding columns in another table?"Chris Chandler" <see@.top.com> wrote in message
news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>I have a report generated in Crystal 10 that is exported to the SQL server
> into its own DB. I finally go the report filtered out enough to where it
> puts
> each person with their designated type (i.e. Store location). My question
> isthis: is it possible to have a query of some sort to look at the
> employee
> type and copy all corresponding people in subsequesnt tables that are
> associated with that type to another Table that actually corresponds with
> their actual store? The 4 Fields that are generated by Crystal
> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it
> is
> possible to analyse the Employee_Type column, then any thing that is
> corresponding with says DA and has coresponding information in the tables
> across from it and then copy the information from those columns to the
> correspoding columns in another table?
It is probably possible, but it would be much easier to help you if you
could post the DDL and some INSERTS with sample data.
What does the Crystal table look like when it is finished? Give us the
CREATE TABLE statement and some sample INSERTs.
What do your other tables look like that you would like to pull the data
from based on the crystal table's TYPE column.
What do you want your final output to look like or your final table? Give
us the CREATE TABLE statement for that as well and we should be able to help
you out.
Rick Sawtell
MCT, MCSD, MCDBA|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>>I have a report generated in Crystal 10 that is exported to the SQL
>>server
>> into its own DB. I finally go the report filtered out enough to where
>> it puts
>> each person with their designated type (i.e. Store location). My
>> question isthis: is it possible to have a query of some sort to look at
>> the employee
>> type and copy all corresponding people in subsequesnt tables that are
>> associated with that type to another Table that actually corresponds
>> with their actual store? The 4 Fields that are generated by Crystal
>> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
>> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if
>> it is
>> possible to analyse the Employee_Type column, then any thing that is
>> corresponding with says DA and has coresponding information in the
>> tables across from it and then copy the information from those columns
>> to the correspoding columns in another table?
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Hm I would gladyl do so but I am so new to SQL and all that I am not sure
where or how to get that exact info. When I go to export it, I just use the
Export Wizard|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>>I have a report generated in Crystal 10 that is exported to the SQL
>>server
>> into its own DB. I finally go the report filtered out enough to where
>> it puts
>> each person with their designated type (i.e. Store location). My
>> question isthis: is it possible to have a query of some sort to look at
>> the employee
>> type and copy all corresponding people in subsequesnt tables that are
>> associated with that type to another Table that actually corresponds
>> with their actual store? The 4 Fields that are generated by Crystal
>> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
>> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if
>> it is
>> possible to analyse the Employee_Type column, then any thing that is
>> corresponding with says DA and has coresponding information in the
>> tables across from it and then copy the information from those columns
>> to the correspoding columns in another table?
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Also, what happens is when Crystal generates the report, it has 1 table
with 4 fields as stated above. These fields have about 1400 records per
field. They are sorted by Employee Type (ie the store they work at). Again
this is all stored by type in one field. To a point this is fine, but is
there a way to either get Crystal to create 11 tables out of the one big
report or do I need some sort of code or query to break this down when it
is exported?
I am real real new to this so have patience with me. I am looking thru al
teh help files and even going thru the SBS SQL Server 2000 Programming book
from Microsoft.
Copying tables based on information
I have a report generated in Crystal 10 that is exported to the SQL server
into its own DB. I finally go the report filtered out enough to where it puts
each person with their designated type (i.e. Store location). My question
isthis: is it possible to have a query of some sort to look at the employee
type and copy all corresponding people in subsequesnt tables that are
associated with that type to another Table that actually corresponds with
their actual store? The 4 Fields that are generated by Crystal
are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it is
possible to analyse the Employee_Type column, then any thing that is
corresponding with says DA and has coresponding information in the tables
across from it and then copy the information from those columns to the
correspoding columns in another table?
"Chris Chandler" <see@.top.com> wrote in message
news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>I have a report generated in Crystal 10 that is exported to the SQL server
> into its own DB. I finally go the report filtered out enough to where it
> puts
> each person with their designated type (i.e. Store location). My question
> isthis: is it possible to have a query of some sort to look at the
> employee
> type and copy all corresponding people in subsequesnt tables that are
> associated with that type to another Table that actually corresponds with
> their actual store? The 4 Fields that are generated by Crystal
> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it
> is
> possible to analyse the Employee_Type column, then any thing that is
> corresponding with says DA and has coresponding information in the tables
> across from it and then copy the information from those columns to the
> correspoding columns in another table?
It is probably possible, but it would be much easier to help you if you
could post the DDL and some INSERTS with sample data.
What does the Crystal table look like when it is finished? Give us the
CREATE TABLE statement and some sample INSERTs.
What do your other tables look like that you would like to pull the data
from based on the crystal table's TYPE column.
What do you want your final output to look like or your final table? Give
us the CREATE TABLE statement for that as well and we should be able to help
you out.
Rick Sawtell
MCT, MCSD, MCDBA
|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Hm I would gladyl do so but I am so new to SQL and all that I am not sure
where or how to get that exact info. When I go to export it, I just use the
Export Wizard
|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Also, what happens is when Crystal generates the report, it has 1 table
with 4 fields as stated above. These fields have about 1400 records per
field. They are sorted by Employee Type (ie the store they work at). Again
this is all stored by type in one field. To a point this is fine, but is
there a way to either get Crystal to create 11 tables out of the one big
report or do I need some sort of code or query to break this down when it
is exported?
I am real real new to this so have patience with me. I am looking thru al
teh help files and even going thru the SBS SQL Server 2000 Programming book
from Microsoft.
sql
into its own DB. I finally go the report filtered out enough to where it puts
each person with their designated type (i.e. Store location). My question
isthis: is it possible to have a query of some sort to look at the employee
type and copy all corresponding people in subsequesnt tables that are
associated with that type to another Table that actually corresponds with
their actual store? The 4 Fields that are generated by Crystal
are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it is
possible to analyse the Employee_Type column, then any thing that is
corresponding with says DA and has coresponding information in the tables
across from it and then copy the information from those columns to the
correspoding columns in another table?
"Chris Chandler" <see@.top.com> wrote in message
news:Xns959C8912B154Dnospmnet@.207.46.248.16...
>I have a report generated in Crystal 10 that is exported to the SQL server
> into its own DB. I finally go the report filtered out enough to where it
> puts
> each person with their designated type (i.e. Store location). My question
> isthis: is it possible to have a query of some sort to look at the
> employee
> type and copy all corresponding people in subsequesnt tables that are
> associated with that type to another Table that actually corresponds with
> their actual store? The 4 Fields that are generated by Crystal
> are:DE_Employee_Type, DE_Employee_EmployeeID, DE_Employee_EmployeeName,
> DE_Employee_EmployeeIsInactive. I guess the query I am looking for if it
> is
> possible to analyse the Employee_Type column, then any thing that is
> corresponding with says DA and has coresponding information in the tables
> across from it and then copy the information from those columns to the
> correspoding columns in another table?
It is probably possible, but it would be much easier to help you if you
could post the DDL and some INSERTS with sample data.
What does the Crystal table look like when it is finished? Give us the
CREATE TABLE statement and some sample INSERTs.
What do your other tables look like that you would like to pull the data
from based on the crystal table's TYPE column.
What do you want your final output to look like or your final table? Give
us the CREATE TABLE statement for that as well and we should be able to help
you out.
Rick Sawtell
MCT, MCSD, MCDBA
|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Hm I would gladyl do so but I am so new to SQL and all that I am not sure
where or how to get that exact info. When I go to export it, I just use the
Export Wizard
|||"Rick Sawtell" <quickening@.msn.com> wrote in
news:#WbDFFqxEHA.1296@.TK2MSFTNGP10.phx.gbl:
> "Chris Chandler" <see@.top.com> wrote in message
> news:Xns959C8912B154Dnospmnet@.207.46.248.16...
> It is probably possible, but it would be much easier to help you if you
> could post the DDL and some INSERTS with sample data.
> What does the Crystal table look like when it is finished? Give us the
> CREATE TABLE statement and some sample INSERTs.
> What do your other tables look like that you would like to pull the data
> from based on the crystal table's TYPE column.
> What do you want your final output to look like or your final table?
> Give us the CREATE TABLE statement for that as well and we should be
> able to help you out.
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Also, what happens is when Crystal generates the report, it has 1 table
with 4 fields as stated above. These fields have about 1400 records per
field. They are sorted by Employee Type (ie the store they work at). Again
this is all stored by type in one field. To a point this is fine, but is
there a way to either get Crystal to create 11 tables out of the one big
report or do I need some sort of code or query to break this down when it
is exported?
I am real real new to this so have patience with me. I am looking thru al
teh help files and even going thru the SBS SQL Server 2000 Programming book
from Microsoft.
sql
Thursday, March 8, 2012
copying database backup file
This is a pretty basic question, but I've generated a backup file for one of my SQL 2000 databases, and I need to copy the backup file to another computer so I can burn it on CD. Whenever I try to copy the file, I get an error message saying that the file is in use by another process and can't be copied. I have tried detaching the database, shutting down Enterprise Manager, stopping the MSSQL service, but all to no avail. There must be a way to do this, but I can't get it to work. Does anyone have any ideas?This shouldn't happen for the backup file, unless you are accessing the backup somehow. What is the filename you backuped up to? have you tried stopping SQL Server, then copying? Since I don't want to assume anything, I'll add this: make sure you are copying the backup file, not the mdb or ldf file.|||If you used Enterprise Manager, you may want to make sure you remove the backupfile from the SQLserver Backup options in All Tasks. But it is intriguing that the file is still in use.|||I tried all of the suggestions posted, but the only thing that ended up working was to rename the backup. The original backup had the same name as the database, but once I made another backup with a different name, I was able to copy the file. Thanks again for the help!
Copying data from PRD to TST
I've got two DBs in the same SQL instance. They are named TST and PRD. I am using 2.0 so there are many ASP generated tables also.
Every once in a while I want to refresh data from PRD to TST. But I don't want to copy the data from ASP tables.
What is the easiest way to do so?
I moved your post from the FAQ fourm to here. Please note that the FAQ forum is for posting answers to commonly asked questions, not asking questions.
Ryan
|||I've always used SQL Server's built-in Data Transformation Services (DTS) to transfer data from one database to another. Be sure not to check the option to Create Destination Objects; choose only to Copy Data.|||Can you suggest a good resource for DTS? If I Google, there are so many hits that it is kinda hard to find a good one.|||Which version of SQL Server are you running? (Please be sure to put this information into any of your posts related to SQL Server.)|||Sorry about that. SQL Server 2005.|||Well, I haven't used SQL Server 2005 much; I currently only have SQL Express on my machine, and no Management Studio. However, I found this article which might help you get started:SQL Server 2005 Integration Services - Import and Export Wizard.
Subscribe to:
Posts (Atom)