Synametrics Technologies

Hi there, I am trying to find some way of copying data from my local install of SQL Server Express to a remote install. I cannot install WinSQL on the remote machine, and I cannot use LAN-style copying methods as it is accross the Internet. I was hoping to use WinSQL's 'Generate INSERT INTO statements' function, and then run in the resulting SQL scripts using the native Microsoft SQL Server command line tool on the remote machine. Unfortunately, WinSQL surrounds table names and column names with double quotes in the resulting SQL scripts, which the SQL Server command line tool cannot cope with. Is there any way of controlling this feature, and perhaps turning them off? Note that I am assuming I cannot use DataBags, since that would require installing WinSQL on the remote machine also. Any help gratefully received.

Hi, Are you able to connect to both remote and local database from your WinSQL running on local machine? If yes, try using the Export Wizard. Refer to http://www.synametrics.com/SynametricsWebApp/MovieImportExportConnected.jsp to watch a tutorial video on this topic. Regards, Hunaid. >Hi there, > >I am trying to find some way of copying data from my local install of SQL Server Express >to a remote install. I cannot install WinSQL on the remote machine, and I cannot use >LAN-style copying methods as it is accross the Internet. > >I was hoping to use WinSQL's 'Generate INSERT INTO statements' function, and then >run in the resulting SQL scripts using the native Microsoft SQL Server command line >tool on the remote machine. > >Unfortunately, WinSQL surrounds table names and column names with double quotes in >the resulting SQL scripts, which the SQL Server command line tool cannot cope with. >Is there any way of controlling this feature, and perhaps turning them off? > >Note that I am assuming I cannot use DataBags, since that would require installing >WinSQL on the remote machine also. > >Any help gratefully received.