PDA

View Full Version : Copy SQL Server database from my Pc to web site


MartinJackson
11-12-2007, 09:06 AM
I have my SQL Server database created on my PC with tables and data added.
I have created an empty database for my web domain using Helm.
I need to copy tables and data to web database and then connect in my application.

What are my options to copy and add data?

I can view my empty web db and my populated pc db in MS SQL Server Management Studio Express.
I can generate generate create tables scripts and run them in web db which execute successfully but don't show up.

Martin
scambler
11-12-2007, 09:14 AM
Martin

Have you tried using myLittleBackup :thumbup1:

http://www.csnmforums.com/showthread.php?t=1014
MartinJackson
17-12-2007, 08:35 AM
This works great for restoring all tables but it removes other additional tables in the destination database.
I would like to copy a set of tables in a database across and leave others intact.
Carl Shepherdson
17-12-2007, 08:48 AM
MyLittleBackup will restore everything from the database you are restoring.
MartinJackson
17-12-2007, 09:04 AM
Yes it does, but it deletes any newly added tables which I want to keep.
Example I have web db = tables T1, T2, T3. I want to copy just T1 and T2 from my local db.
Using MyLittleBackup deletes T3 which may have user collected data.
I was hoping for a quick way?
Carl Shepherdson
17-12-2007, 09:06 AM
Does anyone else have this problem?
Mark Voss
17-12-2007, 09:17 AM
I would like to copy a set of tables in a database across and leave others intact.
Can't you use the SQL Server 2000 DTS Import/Export wizard?
MartinJackson
17-12-2007, 03:08 PM
This is not available to me using SQL Server 2005 Management Studio Express.

I guess I thought this would be some simple facility in Management Studio I just couldn't find along with Generate Scripts.
Mark Voss
17-12-2007, 06:07 PM
This is not available to me using SQL Server 2005 Management Studio Express.
It is if you download and install the Microsoft SQL Server 2005 Express Edition Toolkit. (http://msdn2.microsoft.com/en-gb/express/bb410792.aspx)

Install the tools and you'll find the DTS Import/Export wizard at C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe.