Pozdrav,
Radim asp.net web stranicu u Visual studiu. SQL baza je exportana i prilikom importa na phpmyadmin (radim migraciju sa localhosta na server) javlja sljedeće greške:
2923 errors were found during analysis.
- Unexpected character. (near "" at position 1)
- Unexpected character. (near "" at position 3)
- Unexpected character. (near "" at position 5)
- Unexpected character. (near "" at position 7)
..................
Ako me možete uputiti u rješavanje ovog problema.
Hvala
Kod sqla je sljedeći:
USE [master]
GO
/****** Object: Database [AppDb] Script Date: 12.01.2018 17:18:02 ******/
CREATE DATABASE [AppDb]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'AppDb', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\DogadajiAppDb.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = N'AppDb_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\DogadajiAppDb_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO
ALTER DATABASE [AppDb] SET COMPATIBILITY_LEVEL = 140
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [AppDb] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [AppDb] SET ANSI_NULLS OFF
GO
ALTER DATABASE [AppDb] SET ANSI_PADDING OFF
GO
ALTER DATABASE [AppDb] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [AppDb] SET ARITHABORT OFF
GO
ALTER DATABASE [AppDb] SET AUTO_CLOSE ON
GO
ALTER DATABASE [AppDb] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [AppDb] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [AppDb] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [AppDb] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [AppDb] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [AppDb] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [AppDb] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [AppDb] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [AppDb] SET ENABLE_BROKER
GO
ALTER DATABASE [AppDb] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [AppDb] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [AppDb] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [AppDb] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [AppDb] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [AppDb] SET READ_COMMITTED_SNAPSHOT ON
GO
ALTER DATABASE [AppDb] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [AppDb] SET RECOVERY SIMPLE
GO
ALTER DATABASE [AppDb] SET MULTI_USER
GO
ALTER DATABASE [AppDb] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [AppDb] SET DB_CHAINING OFF
GO
ALTER DATABASE [AppDb] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [AppDb] SET TARGET_RECOVERY_TIME = 60 SECONDS
GO
ALTER DATABASE [AppDb] SET DELAYED_DURABILITY = DISABLED
GO
ALTER DATABASE [AppDb] SET QUERY_STORE = OFF
GO
USE [AppDb]
GO
ALTER DATABASE SCOPED CONFIGURATION SET IDENTITY_CACHE = ON;
GO
ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = OFF;
GO
ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET LEGACY_CARDINALITY_ESTIMATION = PRIMARY;
GO
ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 0;
GO
ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET MAXDOP = PRIMARY;
GO
ALTER DATABASE SCOPED CONFIGURATION SET PARAMETER_SNIFFING = ON;
GO
ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET PARAMETER_SNIFFING = PRIMARY;
GO
ALTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = OFF;
GO
ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET QUERY_OPTIMIZER_HOTFIXES = PRIMARY;
GO
USE [AppDb]
GO
/****** Object: Table [dbo].[__MigrationHistory] Script Date: 12.01.2018 17:18:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[__MigrationHistory](
[MigrationId] [nvarchar](150) NOT NULL,
[ContextKey] [nvarchar](300) NOT NULL,
[Model] [varbinary](max) NOT NULL,
[ProductVersion] [nvarchar](32) NOT NULL,
CONSTRAINT [PK_dbo.__MigrationHistory] PRIMARY KEY CLUSTERED
(
[MigrationId] ASC,
[ContextKey] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Cities] Script Date: 12.01.2018 17:18:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Cities](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](max) NULL,
CONSTRAINT [PK_dbo.Cities] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Events] Script Date: 12.01.2018 17:18:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Events](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](max) NULL,
[Description] [nvarchar](max) NULL,
[Price] [nvarchar](max) NULL,
[Category] [nvarchar](max) NULL,
[MainImage] [nvarchar](max) NULL,
[Address] [nvarchar](max) NULL,
[City] [nvarchar](max) NULL,
[Location] [nvarchar](max) NULL,
[Date] [datetime] NOT NULL,
[CreatedTime] [datetime] NOT NULL,
[Age] [nvarchar](max) NULL,
[Facebook] [nvarchar](max) NULL,
[Twitter] [nvarchar](max) NULL,
[GmailPlus] [nvarchar](max) NULL,
[PinIt] [nvarchar](max) NULL,
[InShare] [nvarchar](max) NULL,
CONSTRAINT [PK_dbo.Events] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[News] Script Date: 12.01.2018 17:18:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[News](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Title] [nvarchar](max) NULL,
[Description] [nvarchar](max) NULL,
[Date] [datetime] NOT NULL,
[CreatedTime] [datetime] NOT NULL,
CONSTRAINT [PK_dbo.News] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT [dbo].[__MigrationHistory] ([MigrationId], [ContextKey], [Model], [ProductVersion]) VALUES (N'201801121535370_InitialCreate', N'dogadajiApp.Data.DogadajiAppContext', 0x1F8B0800000000000400ED5ADB6EE336107D2FD07F10F4D402592B979736B077E13AC9C2682EC62AD9775A1A3BEC52942A5259FBDBF6A19FD45FE85057EA625B8EA2386D1701027BC4391CCE8D3323FFFDEDAFE18795C78C270805F5F9C83C191C9B0670C777295F8ECC482EDEFD627E78FFE30FC34BD75B199FB375676A1D727231321FA50CCE2D4B388FE01131F0A813FAC25FC881E37B16717DEBF4F8F857EBE4C402843011CB30869F222EA907F117FC3AF1B903818C08BBF15D6022A5E3133B46356E890722200E8C4CD75F1297FC41C74130B8209298C698518272D8C016A64138F7259128E5F983005B863E5FDA011208BB5F0780EB16840948A53F2F96B73DC8F1A93A88553066504E24A4EFED097872966AC6AAB23F4BBF66AE39D4DD25EA58AED5A963FD8DCC097E358DEA46E71316AA4575D50E126B0C14DF91517D7A94BB037A8DFA3B322611935108230E910C093B3266D19C51E77758DFFB5F808F78C4982E220A89CF4A0424CD423F8050AE3FC122157CEA9A8655E6B3AA8C399BC6931C6BCAE5D9A969DCE2E664CE20F7004D05B6F443F8081C4222C19D112921E40A03621DD676AFECA5FE67BBA1CB61EC98C60D595D035FCAC791891F4DE38AAEC0CD28A9040F9C62A821930C23286F32B40AF36D35EAE513CAF81CABC68CDFCDFABA66AD6F7201C2096990847CCF7BCD42EAF47FA2092A7BE987EBDE37BA21944F3DB2ECFF4863D70D4188FE55177B65CF9B5CFB0E791577C374929B467DBEA72A9E6A01BB432521A8E04D783B628D5FC155AEB04A99FBFE97DE37BAFF4A553EEB7D9F8F1EA16CC6A2FEBD7F86E12C7BDF65CAED47121EECBEBE85AFE239D7B5E2FB7E5B6F8B072AD97FEBBA3E70FEDCEED2D8B349BC7F21CC842D3C533D825553518A2D59EAE822554159F604DA0659DC8714305C0A41923E6F306972882A775CE13671A735F30EF624526BCC09B94951B94A8AFED54A1AD8ACD1B53674BAC31B1204E8445AE79B520C3B697B27EFECFD3B422FC1B01CD1D018E6D2E63B61FC613155798A5BA3A457341452259C39516E3271BDDAB20607D8A0DF6CC3928DAB09A8D07BB65C7D4E586A393276870A42A1C32B3C9687168F4F08B91869B955638BC70E8491B021994D7C16797C5342DCC69D34133A7F42A9230CAD8ADC55D55835DD54D27255D3ADEC90464B273B2481B5BF2136F01DDA129B104A97800E547AD01E2FEDCB74A494D41EA3E8BA749882DA1E496BAB74288DDC1E2B6F9C74A49CB8C7E9E27C5F3A59C30DB00DA1E87A749482BA87F5E36BB964F698B2C769F43BB97428FDC11E5AAEDA6ABC9F958A9E450729A8ED91F2A64407CA89ED71B4A64347D2C87B4457D25694A22B21B5C7C89B8652DAC9886F2687C7B549A70CDE84D0228137B3F593BFD342BFE46109E97019FC7039A1574FAB55B6D525F9EE79855BA964876955B9FBC54EADCC4C9698062AEA89BAAAC4B4D742829738AAFD279B301AD7F1D9821BC2E902844CFA5CF3F4F8E4B4F276E8EDBCA9B18470598BD735AFDEA853A5D19DADF89E4DA83E49E74F2474306FFEE491D5CF3A52E79720FF6B5DB51A5574C22BBD3DE884547D43D009ACF616A0135A65D2DFED98DA34BF13507562DFCD2DB4A9928B9FE50B4D959E8D357E21D35527EF9DC02AD3F54E58B5097AB730D4A7E49D902A93F03E1273BD2EFCD7E6E5D27CF94D25E60347F47E73E2FA3471E70878BD71009C948828E9DC47A11309B399719BE1F0E6D9701372364FEE32376EC2ED3451AED7D7434BFF79D510BD8D2E0B08F5632B0E8E72BE02345B33E50B3FF30B3C902E51B6A47AFB82C40652927128E98238121F3B787FC62F443E131629B5797370A7FC2E924124C742803767A5D1CDD0DABE7F3C362FCB3CBC8BC347BCC411504CAA5CFD8EFF1651E6E6725F35B8FA0608E5D469AA41A96CA952CE729D23DDFABC2550AABE0B0880AB44750F5EC0104CDC719B3CC173647B10700D4BE2ACB3366933C86E4394D53EBCA06419124FA418053F7E451F76BDD5FB7F005C6B27AC65280000, N'6.2.0-61023')
SET IDENTITY_INSERT [dbo].[Cities] ON
INSERT [dbo].[Cities] ([Id], [Name]) VALUES (1, N'Zagreb')
INSERT [dbo].[Cities] ([Id], [Name]) VALUES (2, N'Split')
INSERT [dbo].[Cities] ([Id], [Name]) VALUES (3, N'Rijeka')
INSERT [dbo].[Cities] ([Id], [Name]) VALUES (4, N'Osijek')
INSERT [dbo].[Cities] ([Id], [Name]) VALUES (5, N'Pula')
INSERT [dbo].[Cities] ([Id], [Name]) VALUES (6, N'Dubrovnik')
SET IDENTITY_INSERT [dbo].[Cities] OFF
SET IDENTITY_INSERT [dbo].[Events] ON
INSERT [dbo].[Events] ([Id], [Name], [Description], [Price], [Category], [MainImage], [Address], [City], [Location], [Date], [CreatedTime], [Age], [Facebook], [Twitter], [GmailPlus], [PinIt], [InShare]) VALUES (1, N'', N'', N', N'', N'', N'', N'', N'', CAST(N'2017-12-21T20:30:00.000' AS DateTime), CAST(N'2018-01-12T16:35:37.763' AS DateTime), N'', N'', N'', NULL, NULL, NULL)
USE [master]
GO
ALTER DATABASE [AppDb] SET READ_WRITE
GO