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
Martin Have you tried using myLittleBackup :thumbup1: http://www.csnmforums.com/showthread.php?t=1014
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.
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?
This is not available to me using [FONT=Verdana, Arial, Helvetica, sans-serif][SIZE=-1][FONT=Verdana, Arial, Helvetica, sans-serif][SIZE=-1] SQL Server 2005 Management Studio Express. I guess I thought this would be some simple facility [/SIZE][/FONT][/SIZE][/FONT][FONT=Verdana, Arial, Helvetica, sans-serif][SIZE=-1][FONT=Verdana, Arial, Helvetica, sans-serif][SIZE=-1]in Management Studio I just couldn't find along with Generate Scripts. [/SIZE][/FONT][/SIZE][/FONT]
It is if you download and install the Microsoft SQL Server 2005 Express Edition Toolkit. Install the tools and you'll find the DTS Import/Export wizard at C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe.
