I need to 'copy' selective (filtered) rows from table 'A' to table 'B' on a regular basis, but only if they do not exist in table 'B'.
If rows get deleted from table 'A' they must remain table 'B'. If rows change in table 'A' (unlikely) they should be update in table 'B'
What feature of SQL should I be using?
- triggerering a stored procedure on Insert
- replication
- SSIS
HI,
Is it possible in SQL Server to restore Databases partially?
In the sense, I want to backup just 2 tables from a database & restore them, instead of having to take a backup of the entire database & restore the entire database.
One way to do would be to export data & then importing data for only those selective tables, but I dont want to do that, bcause that would probably take more time & can be error prone.
Thanks
Raman.
I have a table that I am basically reduplicating a couple of times for each part of this database that I want to create.Each table basically has the same data: The tables will be called motherTable, fatherTable, sonTable, daughterTable and so on.I am pretty much using the following in each column: UserID, MotherID(or FatherID or SonID, etc., etc. and so on for each unique table), FirstName, LastName, MiddleName, BirthPlace, Photo, Age.I don't see an option to copy a table and just modify the second ID part and rename that table accordingly.How can I make this an easier way of creating these similar tables without retyping all these columns over and over again?Thanks in advance.
View 4 Replies View RelatedI need to copy data from warehouse tables to master tables of different SQL instances. Refresh need to done once in an hour. What is the best way to do this? SQL agent jobs or SSIS packages?
View 3 Replies View RelatedIs there anyway I can copy tables and stored procedures from one MS SQL server database to another? I presume there is, so how is it done.Thanks
View 6 Replies View RelatedI have two databases and want to copy tables (with table data) and stored procedures from one database to another.both databases have the same name (so management studio is not letting me have both up)....what should I do?thanks.
View 5 Replies View RelatedWhat is the easiest way for me to copy my database tables so that I could use the copy as a template to work on for setting primary keys, and normalizing the data?
Thank you in advance for your help.
Shari
A question from a beginner. Is there a simple command to create a copy of at table with its original attributes. I would like to take a table for a year and copy it to an archive file with the year appended to the name, i.e. myfile copied to myfile02
View 1 Replies View RelatedI need a job to copy data between 2 databases on the same server. (2nd one will be used for reporting purposes, and I'll run my job nightly)
Can anyone at least point me in the right direction for Transact-SQL statements or which process to start with.
I tried a DTS job but it fails on the schedule. Only runs immediatly but then fails.
Thanks..
Hello all
I have a table named Configuration and I want to make a copy of this table.
I already have the table with the same structure named Configuration1. All I want to do is copy data from Configuration to Configuration1
How do I do it? I tried various queries:
SELECT *
INTO configuration1
FROM configuration
GO
Results:
(395 row(s) affected) but configuration1 is empty.
----------------------
Create configuration1 like configuration
Results:
Error near like
------------------------
So how do i achieve this?
Thanks much guys/girls....
Hi
I have a DB2 database server.It has 2000+ tables...And I have a MS SQL database server.It has got the same tables.With same schema...
I want to take all of that tables datas to MS Sql database's tables....
I try to use DTS Import Data Wİzard but it gace an erro which is Unknown Error!!!
Now;
I try to make a DTS which is capable with doing this mission...
I want to create one DTC package and the source table and destination table names will be changed dynamically...Probably i should use ActiveX Task or Dynamic PropertTask...
Despite i have searched from net very much i couldnt find any helpfull article or sample for 3 days...I have also checked this one;
http://www.sqldts.com/default.aspx?246
But it hasnt helped me too..
I really wish thatsomebody can help me...
Thank u all
Osman AYHAN
Hi everyone!
I want to copy from DB certain tables to an other DB. How can I do that with SQL Server 2005. I would prefer an SQL string solution instead of buttonclicking solution.
Thanks a lot and greetings from Vienna, Austria
landau
Hi. I have a SQL statement currently ending with "ORDER BY sc.TypeID, sc.ObjetID DESC"where the TypeID can be of value 1,2,3,4,5,6,7,8, 9 and 10. What I would like to achieve is to selectively order the datas by TypeID, meaning in this case that I want ALL the TypeID of value "1" to come first and then all the rest ("2" and higher) un-ordered. This is important that the rest remains unordered by their TypeID as I only want them to be ordered by their ID (ObjetID DESC). Is that possible? If yes how?Thank you.Francis
View 4 Replies View RelatedHello all,
Is there a way to do a selective restore? I need to create a dev db and the prod backup is 17 gig and I have a space crunch on the server. My idea was to restore the complete backup and subsequently shrink the db size after truncating data in tables which are not frequently used? Is that a good idea. Any help will be appreciated.
Thanks in advance!
Hi,
I need to be able to export from an existing database, all fields with a certain column id. I have been pointed in the direction of bcp, however I am having difficulty finding the right syntax.
Thanks,
D.
(P.S. MSSQL 2000 Server)
I have
table T2
id amount ss
1142
2151
3162
4172
table T3
idamount ss
131
142
251
362
472
481
491
I run
UPDATE t2, t3 SET t2.amount = t3.amount
WHERE t2.id1=t3.id and t3.ss=1;
T2 becomes
ID1amount ss
132
251
3162
492
but I want t2 to be
ID1amount ss
132
251
3162
4 82
how can I do that?
Thanks
Is it possible to use replication for inserts and updates only for some tables and inserts updates and deletes on others. I want to be able to delete data from the source database but not my replicated database. Does anyone know of a way to use replication to facilite this?
Thanks for any input you can provide.
I'm in the current mode of migration from WIn2k and I 'm trying to setup user where they are only allowed access to one table.
If I grant thenm read /write access to the db they can obviously see all of the db due to the size of the db I do not wish to go down the root of denying every table as there is over 100. Is there an easier way??
Hi,
I have 2 databases and each of them has different tables. I want to copy all of tables of database A to database B while keeping the existing tables of database B.
What is the best solution?
Thanks
I need to duplicate all the tables owned by dbo to another object ownername in a database within the same database.That means,if there are 100 table owned by dbo in a 'Database A'. I need to have a total of 200 tables in the same database 100 each for dbo and 100 for another user.They should have same schema including the keys etc and data.How is this possible?Through DTS we can't copy them to the same databse.We do not want to have a temp db inbetween to complete this process.Any ideas on how to do this? NOTE:This is not a one time job.
Thanks.
Sheila.
I want to make a copy of a table and this table has several constraints and
I would like to keep all of them
How should I do it? Thank you
I need to copy the data in the last name table to the field2 table do i use the update query in sql 2005?
View 5 Replies View Relatedcopy the tables of a database that will keep the indexes,constraints etc.? I'll be using SQL 2008 or Visual Studio 2008. The basic SSIS package will not work since our databases are being updated from time to time. (e.g. new columns/tables meaning we need to redo the SSIS package everytime there are changes).
View 4 Replies View Relatedhow can i copy all table and data to another database
View 3 Replies View RelatedI need to construct a database that only has certain elements of another db. I would like to write one batch of commands to either create the tables or update them if the table already exists. I've found examples to update sections of a table, but not the entire thing. Any assistance or relavent links are greatly appreciated.
Thanks,
I need to construct a database that only has certain elements of another db. I would like to write one batch of commands to either create the tables or update them if the table already exists. I've found examples to update sections of a table, but not the entire thing. Any assistance or relavent links are greatly appreciated.
Thanks,
Hi everyone
I have 2 severs. I want to copy 3 tables (data, table definition, inex..ect) from sever A to sever B.
What is the best way to do it?
Please help!
Hi All
[i am fairly new to SSIS]
My current project copies source tables to destination tables. Structure at both sides is identical so it€™s kinda €˜repetitive€™ process to drag source and destination components.
So I want to create component which should do following €“
select source connection
select source tables
select destination connection
select all destination table
map source table to destination table
validate columns mapping based on the names
To enhance, I also would like to support creation and mapping of custom values.
So I would really appreciate any kind of input in creating this component. Currently I am reading tutorials on creating SSIS components.
Thanks in advance
Goodday
Can anyone help please.
I have made a database and need to duplicate the tables to represent new catogaries. The definitions in the tables will stay the same , just the table names will change.
Is there a way to copy and past / duplicate tables without retyping all the definitions each time.
Thanks
Rob
Hi!
Can someone tell me how I can copy my database which is made with SQLExpress or the tables to another SQL server. The servers could be SQL server 2000 and SQLExpress.
Thanks!
I have 3 tables(Table1, Table2, Table3) and i want this 3 tables to be inserted/copied to NewTable.
this is my query and it is good only for one table:
INSERT INTO NewTable
SELECT *
FROM Table1;
Can you help me to solve this problem?
Thanks....
I was trying to use the case statement in where clause so that the comparison (> , <, =) can be made depending upon the value of the local variable @fl.
PLease tell me how to do that. Or suggest me how can I make selective comparison (<,>,=) in where clause depending upon a local variable. Please note that I donot want to use if/else satement and write select statement everytime based on the local variable as in that case the code length will be huge. Please suggest me a coensized query.
SQL that I queried:
use pubs
go
declare @fl int
select fl = 3
select * from titles
where case fl when 1 then price > 90
when 2 then price < 90
when 3 then price = 90
end
The following error is given
Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near '>'.
Can I transfer data from one database to the other for only selected records
pls help
thanks
sunthar