May 14, 2009 at 2:24 pm
We are a small startup company and we are using SQL Server 2005 Express Edition. We had a database say DB1. Now, we are working on another database DB2. Some of the fields in the tables are different and their datatypes also differ. We also have some new stored procedures in DB2 which dont exist in DB1. We now want to copy all the data, including the tables, stored procedures and functions everything from DB1 to DB2. Can someone suggest a mechanism to do this?
May 15, 2009 at 12:17 am
I think you can download the basic management studion, generate script and then dump the data using insert into queries.
never used it, it will be easier if you have import export wizard avaiable
Sriram
May 15, 2009 at 3:17 pm
We have SQL Server 2005 Enterprise edition installed now. Is there a procedure where I can compare two diferent tables, functions, stored procedures belonging to different databases in the same server and migrate data from one to another. Can i use SSIS for this, never used it and dont knwo how it works
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply