Copy Database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Copy Database

Author

Topic

Funkygibbon69
Starting Member

3 Posts

Posted - 2009-02-04 : 06:41:18

Sorry if this is in the wrong forum.

We have a main server that I want to copy the structure and place onto a users laptop, then I want to copy some records across.
How can I create a script for the structure of the main database then create it on the users laptop when the user requests it?

Thanks in advance

Kind Regards

Funky

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-02-04 : 07:13:07

Because you have posted in SQL Server 2000 (DTS and Replication):

Connect to your server in SQL Server Enterprise Manager
Choose / right click on your database
Choose all task...
Choose generate Skript
The rest ist self-explanatory ...

Webfred

No, you're never too old to Yak'n'Roll if you're too young to die.

rhysmeister
Starting Member

6 Posts

Posted - 2009-02-04 : 07:42:42

If you can use SSIS (which is in 2005) this is much easier with the Transfer Database task. All point and click could be setup in a few miniutes.

http://technet.microsoft.com/en-us/library/ms141204.aspx

Twitter Integration | Ping.fm Integration | SQL Server Blog

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-04 : 09:37:30

quote:
Originally posted by Funkygibbon69

Sorry if this is in the wrong forum.

We have a main server that I want to copy the structure and place onto a users laptop, then I want to copy some records across.
How can I create a script for the structure of the main database then create it on the users laptop when the user requests it?

Thanks in advance

Kind Regards

Funky

Simple Backup and restore.

Funkygibbon69
Starting Member

3 Posts

Posted - 2009-02-04 : 10:58:51

That would be great but I want to be able to create the database within code and copy only a few selected records. The database would be too big to backup and restore onto a laptop. What I'm trying to do is make a few records mobile so the can change them while they are away from the office then check the changes back in when they are back in the office.

Thanks very much for your help so far

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-04 : 11:00:26

Then you should be looking for Merge Replication.

Funkygibbon69
Starting Member

3 Posts

Posted - 2009-02-04 : 11:08:10

Cheers I will look into that section then.

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources