Hi all! I have a problem... My server went down about a week ago, and they are fixing it, in the time that they are fixing it i want to pass my database table with all the information inside it, to another server, and they gave me the database to get all the information from there...
My problem is... how i can pass all the information inside my database to my another database, the database server is sql 2000, and the other is also sql 2000, i want to generate a script so i can pass it to the other database and fill the database with the data in the script...
I have Microsoft Sql server manager, and i try to play around with it, but can't find out how to generate a script that contains all the data from the database or table.. have also the microsoft sql server database publishing wizard... but can't generate the script also...
so if anyone can give me a clue as of how to generate my script with the information from a table, or the whole database...
thank you!...
Oh ok. Prbly its not available in the Express edition. How big is the table (how many records)? I fits a few hundred thousand rows you can do a simple INSERT INTO query. Are the 2 databases on the same server or diff servers?
INSERT INTO server1.db1.dbo.Table (<column list>
SELECT <column list>
FROM server2.db2.dbo.table
WHERE <condition>
This will create the table in the Db1 as well as populate data from table on Db2. You might still need to create the indexes/build the FK's etc.
No comments:
Post a Comment