SQL to SQL export
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=4557
Printed Date: 02 April 2026 at 10:14am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL to SQL export
Posted By: joshb
Subject: SQL to SQL export
Date Posted: 27 July 2003 at 9:19pm
|
Is there an easy way to do this? I have a SQL Server database that I need to export to another server, when I tried, all the default values are gone like I thought and the tables are created by db login and not dbo which is what the stored procedures look for. I tried to edit the stored procs and add in my login id but it doesn't like the naming convention. username-#######, so I am kind of stuck. Any suggetions? ------------- I'm a wannabe programmer that knows how to do nothing but create invalid procedure arguments. http://www.soopportal.com"> 
|
Replies:
Posted By: michael
Date Posted: 28 July 2003 at 9:57am
|
Did you use DTS? If so try using the DTS designer, running a script for the DB first with all defaults etc. and then do a Data Transformation Query. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |