February 9, 2007 at 11:22 pm
How would i take a sqlexpress database from a laptop and merge the data to another sqlExpress on a main datatbase?
Am i in the right forum?
erik
Dam again!
February 9, 2007 at 11:30 pm
U can use Merge replication so that the data in both the databases are in sync. Or if u just want the data in ur laptop to be reflected in ur main database then take a backup of your database and restore over the main database.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 10, 2007 at 12:31 am
Is Merge a replication difficult process? I will read up on it; but can you give me a brief description?
Thanks a lot
erik
Dam again!
February 10, 2007 at 5:25 am
SQLExpress can only be a subscriber in the replication topology so if both your instances are SQLExpress this is not an option.
Also you would need to have installed SQLExpress with advanced services to do this and chosen to install the replication components as they are not installed by default.
If you just need to get the data off the laptop into the main database and you do not have to worry about data conflicts i would just shove them both on the network create a linked server and write a script to manually move the data to your main database. You could a similar thing taking a backup and estoring to the main database server as another database and then sycn using a script.
hth
David
P.S Setting up merge replication in sql server in 2005 is quite easy as you can nearly always get away with just using the wizards and scripting out your setup once your finished. See BOL.
February 11, 2007 at 3:34 am
If you have the space on destination server... then first restore a db copy as different name from Laptop...
Once the db is present on destination server you can use SSIS, CROSS DB join etc...
MohammedU
Microsoft SQL Server MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply